On Wed, 20 Feb 2008 05:43:01 -0800, 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

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