Board logo

Excell to .Txt
steve m - 2/11/14 at 10:45 PM

Hi

Any one got a freeview or cheat so I can convert an Excell doc to a .Txt
Please ................


Steve


ReMan - 2/11/14 at 10:56 PM

Why can't you just open it and "save as" a suitable txt file format?


joneh - 3/11/14 at 07:30 AM

Yup just save as .txt and it'll export as Tab delimeted.


adampage - 3/11/14 at 08:47 AM

So you need to view it in notepad?

If so....
Can you email it to someone with excel to convert it?


steve m - 3/11/14 at 08:59 AM

Hi

Thanks for the response, and saving to .txt is how we are trying to save it,
yet it corrupts in the save

Its a work doc, and has personal info, so emailing it is not an option
Over to out IT dept to bleep it up even more

regards

steve


adampage - 3/11/14 at 09:18 AM

OK cool.
Can you open in excel, then copy into notepad, then save as?

I've done that before to get around excel formatting issues, you can do it with big amounts of data no probs as Notepad is so naïve.

HTH


ReMan - 3/11/14 at 09:45 AM

Thers a number of different text like formats to save it in so worth trying different ones and as mentioned, pasting out and back in, ir directly into another app like notepad.
Someting else you should tryu also its removing as much foramatting/formula/colours/fonts/cell merges before you even try to save it to txt


tegwin - 3/11/14 at 12:00 PM

Save as a CSV.... once its saved, right click on the CSV file and open with notepad.... voila.. a comma delimited text file