PDA

View Full Version : RTF/TXT files to CSV



Vectracious
17th January 2012, 02:32 PM
Anyone know how to convert a RTF or TXT file to CSV so it can open in Excel and each segment of text is in a column?

hazrd
17th January 2012, 09:52 PM
excel can usually do the conversion for you i think. if you open excel, then open the text file, it should auto open the text to columns feature iirc

dglewis80
17th January 2012, 10:15 PM
Sounds about right....

Sent from a dodgy 3G stick.

sooty
17th January 2012, 10:28 PM
excel can usually do the conversion for you i think. if you open excel, then open the text file, it should auto open the text to columns feature iirc
This, open, all files, text file, delimited, values, separated by commas or tabs etc

Vectracious
17th January 2012, 10:28 PM
had to convert RTF to TXT and then it kind of worked - still messy though because of the RTF to TXT conversion...... but it will do.

Thanks guys