ExcelBanter - Convert excel file to flat text file

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert excel file to flat text file (https://www.excelbanter.com/excel-discussion-misc-queries/28605-re-convert-excel-file-flat-text-file.html)

Gary's Student

Convert excel file to flat text file

Try using File Save As... Formatted Text (Space delimited)(*.prn)

If any unwanted characters show up in the .prn file, use Notepad or Wordpad
to remove them
--
Gary's Student

"Lannutslp" wrote:

How can I convert an excel file to a flat text file with no decimals, commas,
slashes or dashes

All times are GMT +1. The time now is 06:33 PM.