Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving Text File as true Fixed Length in Excel 1

Status
Not open for further replies.
robyno

robyno

IS-IT--Management
Sep 23, 2002
12
US
I am trying to use Excel to preprocess a text file and merge some lookup info. I can not seem to save the formatting into a true FIXED record format. Does anyone have any suggestions on saving the file so that the field locations do not shift?
 
Sort by date Sort by votes
Try this:
1. Select the whole sheet and change it to Courier font.
2. With the whole sheet still selected choose FORMAT, COLUMN, AUTOFIT SELECTION.
3. Save to Formatted Text (Space Delimited).

-Larry
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kwbMitel
  • Locked
  • Question
Lost edited data in Excel File
Replies
3
Views
134
Scott24x7
Scott24x7
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
290
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
287
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
861
shytott
shytott
renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
622
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top