Help – I need to extract information from………..

[Kelly]

I am downloading information from Primavera software into Excel. My problem
is that I need to be able to extract part of the information in (1) column
and have it become (2) columns.

Example: 4040 , Excavation Cut and Fill

What I need to have is the 4040 in one column and the Excavation Cut and
Fill in another field. There are approximately 250 line items when downloaded
with several columns. I feel sure there's a way to do this. Can you please
help and tell me how.

Thanks !!!

Kelly Burgess

 

[Ron Rosenfeld]

I am downloading information from Primavera software into Excel. My problem
is that I need to be able to extract part of the information in (1) column
and have it become (2) columns.

Example: 4040 , Excavation Cut and Fill

What I need to have is the 4040 in one column and the Excavation Cut and
Fill in another field. There are approximately 250 line items when downloaded
with several columns. I feel sure there's a way to do this. Can you please
help and tell me how.

Thanks !!!

Kelly Burgess

Use the Data/Text to Columns wizard with a <comma> as the delimiter
--ron

 

[Gary''s Student]

If your data matches your example, then without VBA:

In B1 enter:
=LEFT(A1,4)

and in C1 enter:
=MID(A1,8,255)

The VBA approach should do the same thing

 

[Kelly]

Thanks - That works
Kelly

If your data matches your example, then without VBA:

In B1 enter:
=LEFT(A1,4)

and in C1 enter:
=MID(A1,8,255)

The VBA approach should do the same thing