External Data needs to be separated

  • Thread starter Thread starter Mandy J.S.
  • Start date Start date
M

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
 
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
 
Back
Top