External Data needs to be separated
 

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

External Data needs to be separated
 

Try this in H2:

=LEFT(A2,7)

Copy it down as required.

Hope this helps.

Pete

On Nov 28, 3:54 pm, Mandy J.S.
wrote:
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

External Data needs to be separated
 

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" wrote:

Try this in H2:

=LEFT(A2,7)

Copy it down as required.

Hope this helps.

Pete

On Nov 28, 3:54 pm, Mandy J.S.
wrote:
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

External Data needs to be separated
 

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

Pete

On Nov 28, 5:12 pm, Mandy J.S.
wrote:
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" wrote:
Try this in H2:

=LEFT(A2,7)

Copy it down as required.

Hope this helps.

Pete

On Nov 28, 3:54 pm, Mandy J.S.
wrote:
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- Hide quoted text -

- Show quoted text -