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

--
Gary''s Student - gsnu200769


"Kelly" wrote:

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