| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add spaces to end of field in save as PRN
Hi all,
I have a sheet that I need to save to space delimited(PRN). My dilemma is how to add 12 spaces at the end of a six-character field. The field is as follows 000123 and in the text file I need "000123 " I know I can copy and paste into Access and then use the the Export function and set the fixed-width parameters, but I would prefer to find a way to do this in Excel. Any suggestions greatly appreciated. TIA, Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace spaces at the end of a field | Excel Discussion (Misc queries) | |||
| Save as CSV: extra spaces around commas | Excel Discussion (Misc queries) | |||
| How do I put spaces in a field | Excel Discussion (Misc queries) | |||
| How do you remove excess spaces from an Excel field? | Excel Discussion (Misc queries) | |||
| Adding spaces to a text field | Excel Programming | |||
![Jim[_37_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
