steve m
|
| posted on 2/11/14 at 10:45 PM |
|
|
Excell to .Txt
Hi
Any one got a freeview or cheat so I can convert an Excell doc to a .Txt
Please ................
Steve
Thats was probably spelt wrong, or had some grammer, that the "grammer police have to have a moan at
|
|
|
|
|
ReMan
|
| posted on 2/11/14 at 10:56 PM |
|
|
Why can't you just open it and "save as" a suitable txt file format?
www.plusnine.co.uk
|
|
|
joneh
|
| posted on 3/11/14 at 07:30 AM |
|
|
Yup just save as .txt and it'll export as Tab delimeted.
|
|
|
adampage
|
 posted on 3/11/14 at 08:47 AM |
|
|
Or are you saying you don't have excel?
So you need to view it in notepad?
If so....
Can you email it to someone with excel to convert it?
|
|
|
steve m
|
| posted on 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
Thats was probably spelt wrong, or had some grammer, that the "grammer police have to have a moan at
|
|
|
adampage
|
| posted on 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
|
| posted on 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
www.plusnine.co.uk
|
|
|
tegwin
|
| posted on 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
------------------------------------------------------------------------------------------------------------------------
Would the last person who leaves the country please switch off the lights and close the door!
www.verticalhorizonsmedia.tv
|
|
|
