ExcelBanter

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/28606-convert-excel-file-flat-text-file.html)

Lannutslp

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

Earl Kiosterud

Lannutslp,

To add to that, changing the column widths will change how many spaces are
included between cells (horizontally). Using a non-proportional font, like
Courier, makes this consistent.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Gary's Student" wrote in message
...
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 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com