External Data needs to be separated

[Mandy J.S.]

I have external data linked to columns A through G. In column A is the Task
Name. I have the task names listed in Project as 06-0207_task description.
What I would like to do is have a column that takes out the 06-0207 portion
and puts it into column H. I'd like it to be a formula so that when I update
columns A through G, then H gets updated as well. Any ideas? This is all
then being linked into Access to sort and group on other data that utilizes
the 06-0207 portion of the tasks. Thanks.

Mandy Jo

 

[Pete_UK]

Try this in H2:

=LEFT(A2,7)

Copy it down as required.

Hope this helps.

Pete

 

[Mandy J.S.]

Hi Pete,

I changed the 7 to a blank space and adjusted how the job # is called out in
the schedule. It's a new naming convention and it hasn't been presented to
anyone yet. I am doing all my prep work for a meeting tomorrow about it.
Thanks.

Mandy Jo

 

[Pete_UK]

I'm glad it helped - thanks for feeding back.

Pete