View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mandy J.S. Mandy J.S. is offline
external usenet poster
 
Posts: 4
Default 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