|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2009, 07:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
importing data from a txt file
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. 
|
|
#2
May 15th, 2009, 07:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
importing data from a txt file
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
