Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a working copy of a load file that I have built in Excel. There are
13 columns of data and the sum of the column widths is 251 characters. The last column (120 characters in width) is being dropped from text-view when the PRN is being saved. Is there a way to save the Excel file as a txt file and have it "honor" the spaces between characters? I've tried concatenation of the 13 columns but the spaces "go away" in Excel. I researched on here and found a SCARY macro that I have absolutely no skills to interpret or apply. The macro was to address this problem but I can't use it. Other than that, I've seen no suggestions. Any and all help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to limit long text to column width? | Excel Discussion (Misc queries) | |||
Character limit in cell | Excel Discussion (Misc queries) | |||
255 Character Limit | Excel Discussion (Misc queries) | |||
set column width using character spaces | Excel Discussion (Misc queries) | |||
repeating a character across the width of a column | Excel Worksheet Functions |