Padding Spaces in Excel

D

David Coning

I'm trying to pad spaces onto the end of my data in
Excel. I have a column that is 32 characters wide and the
data in that column is of varying lengths. I want to pad
spaces at the end of this data so that every cell
contains 32 characters, spaces included.

Any ideas?
 
H

hgrove

David Coning wrote...
I'm trying to pad spaces onto the end of my data in Excel. I have
a column that is 32 characters wide and the data in that column
is of varying lengths. I want to pad spaces at the end of this
data so that every cell contains 32 characters, spaces included.
Click to expand...

Something like

=LEFT(YourDataHere&REPT(" ",32),32
 
Top