Excell to comma seperated data
Excell to comma seperated data
(OP)
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
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





RE: Excell to comma seperated data
RE: Excell to comma seperated data
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
RE: Excell to comma seperated data
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Excell to comma seperated data
Thanks for that.
John