Field Lengths

  • Thread starter Thread starter Jasmine
  • Start date Start date
J

Jasmine

We have a spreadsheet that needs to be saved into a text
format to export to another program. The export file that
must be created needs to have the columns a specific
number of spaces. For a field with text in it, is there a
way in Excel to have it created those extra spaces? Any
help would be appreciated.

Thanks!
 
One idea!

Could you add a "helper" column, add the necessary spaces to this "helper"
column, then eliminate the formula, leaving the existing text and spaces
behind, and then delete the original
This would have to be done on a column by column basis.

Text in column A.
Length necessary for export = 50.

Enter this in B1 and copy down as needed:

=A1&REPT(" ",50-LEN(A1))

To remove the formula, and leave just the data and spaces behind, you should
now,
select the data in column B,
Right click in the selection and choose "Copy",
Right click again and choose "PasteSpecial",
Check "Values", then <OK>.

You now have column A with your original data, and column B with your data
plus the necessary spaces appended to it to make up 50 places.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


We have a spreadsheet that needs to be saved into a text
format to export to another program. The export file that
must be created needs to have the columns a specific
number of spaces. For a field with text in it, is there a
way in Excel to have it created those extra spaces? Any
help would be appreciated.

Thanks!
 
Back
Top