Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excell to comma seperated data

Status
Not open for further replies.

Blackcountryman

Electrical
Joined
Jul 14, 2005
Messages
72
Location
GB
I have a column of numeric data in excell that has to be converted for imput into another program.

I have
1
2
3
4
etc.

I need

1,2,3,4,etc.

I thought saving as CSV would do it but is still gives me a column of figures when I view it in notepad

Any ideas

John
 
COnvert columns to rows first, then export, or open in Word and change all ^P to ,
 
IFRs

Thanks. All I needed to do is just open it in word and replace ^P with a comma and that solves the problem. No need to convert to rows first.

Job done, thanks again

John
 
You can also transpose the colum (copy / paste special /transpose) and then save as CSV. No need to go to Word.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top