The software my company is using creates 2 rows of data for each sku which I
can create as a txt file to import into excel 2003.

LIke this:

Sku Description Date added Last Cost
QOH Retail

101 Widget 05/15/09 1.00
24 1.49

How can I get QOH and Retail into their own cell?

Thanks.

If the data comes with commas between each item then give the file a name
with extension CSV and open it with Excel
Otherwise, have a look in Help to see how Data | Text to Columns works
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"rrlogan" wrote in message
...
The software my company is using creates 2 rows of data for each sku which
I
can create as a txt file to import into excel 2003.

LIke this:

Sku Description Date added Last Cost
QOH Retail

101 Widget 05/15/09 1.00
24 1.49

How can I get QOH and Retail into their own cell?

Thanks.