LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Working Around 240 Character PRN Field Width Limit

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to limit long text to column width? [email protected] Excel Discussion (Misc queries) 7 December 2nd 07 07:13 AM
Character limit in cell Jan Excel Discussion (Misc queries) 3 April 21st 06 02:40 AM
255 Character Limit Colin Excel Discussion (Misc queries) 2 March 2nd 06 07:58 PM
set column width using character spaces Troy | yorT Excel Discussion (Misc queries) 3 February 26th 06 11:49 AM
repeating a character across the width of a column gvm Excel Worksheet Functions 4 September 29th 05 05:22 AM


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"