importing data

E

elwyn

Hi again all

I have exported data from a non-excel program and have saved it as a comma
seperated file but when I try to import it into excel the list just uses the
A column with the headings seperated as a comma. I have 8 headings and would
like to each heading to have it's own column when I import it. I am trying
to use Data/Import External Data/Import Data but I cannot for the life of me
figure out how to do this.

MTIA

Elwyn
 
N

nilizandr

I'm not sure about Excel 2003, but in Excel XP, you can paste as value
(as recommended below) or paste with formatting of current document, o
paste with formatting of original.
In Excel XP, after you paste, one of those "smart tips" icons appears
and you can choose pasting options after the fact.

With regard to the CSV file, select that A column with the value
separated by commas, and then go to the data pulldown menu, and selec
"text to columns" indicated that you have text delimited by commas, an
voila! your problem is solved
 
N

nilizandr

I'm not sure about Excel 2003, but in Excel XP, you can paste as value
(as recommended below) or paste with formatting of current document, o
paste with formatting of original.
In Excel XP, after you paste, one of those "smart tips" icons appears
and you can choose pasting options after the fact.

With regard to the CSV file, select that A column with the value
separated by commas, and then go to the data pulldown menu, and selec
"text to columns" and indicate that your text is delimited by commas
and voila! your problem is solved!
P.S. Text to columns is awesome, because you can spearate text that'
delimited by any character(s) at all or just chop data into fixed-widt
columns
 
D

Don Guillett

Use data>text to columns>delimited>comma and look at the format below to see
if it is correct>next.
It's pretty "self explanatory"
 
D

Dave Peterson

Does your windows Regional setting for your list separator match the character
that's used in the .csv file?

Windows start button|Settings|control panel|regional settings|number Tab

Is how I'd check in win98.

Maybe the other program uses a comma and excel (through that windows setting) is
expecting a semicolon.
 
Top