importing data from a txt file

R

rrlogan

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing multiple lines into Excel from txt. 3
excel importing data 16
Sum Prodcut issue from .txt import 1
Complex Count Query 0
Importing a txt file into Excel - 0
Importing Txt file into Excel 9
importing from a *.txt file 4
Data from 2 sheets to create a new sheet with user input? 1

Top