Convert Excel file ti ASCII format to allow a SIFT transfer

P

Paula

Hi, I have read the posts about saving an excel file and converting it to
ASCII file but I do not fully understand although it looks simple.
The remit is I have an excel file containing a huge amount of data but it is
not acceptable as it needs to be in ASCII format.
How do I change the Excel file to ASCII successfully?

Many thanks for your advice.
Paula
 
J

Joel

Saving each worksheet as text data. There are many textt formats that you
can use by doing File - SaveAs and selecting the type of file at the bottom
of the window. Both TXT and CSV are text formats. CSV is each column on the
spreadsheet seperated by a comma.

With saving as Text you loose all the formating and you can only save one
worksheet to one text file.

You can also save the worksheet as a picture which is usful if you want to
show the worksheet in a Power Point Slide presentation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save Excel to ASCII format 2
Convert Excel spreadsheet to Ascii file format 2
How do I convert excel file into ASCII text file with alignment? 2
How do I convert an Excel file to an ASCII file? 1
Excel to ASCII Fixed Format 2
Converting an Excel file to fixed length ASCII (text) file 2
Convert a file to an ASCII 1
How do I convert an Excel file to an ASCII file? 1

Top