Padding Spaces in Excel

  • Thread starter Thread starter David Coning
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I autofill spaces in right justified fields? 1
Split column contents (de-concantenate) 7
Pad field length 2
opening txt documents in excell 1
Padding a text column with leading zeros 7
Excel Help creating Excel formula 1
Add Space Padding 2
Data missing in field in pivot table 1

Back
Top