Excell to comma seperated data

[Blackcountryman]

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

 

[IFRs]

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

 

[Blackcountryman]

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

 

[joerd]

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.

 

[Blackcountryman]

Joerd,

Thanks for that.

John