Padding Spaces onto a Cell

[hcabs99]

Hi

Can anyone help with what im sure is a simple answer, but i am stuck!

I need to create a lot of data which needs to have a fixed length for the cells but the data being entered does not always fit this length. I therefore need to pad these cells out to always ensure they are the correct size. I know how to remove spaces using trim but cannot find a way of reversing it

Any help would be gratefully appreciated

Cheers

Phil

 

[Stormseed]

I would rather use the =LEN() formula to find the exact length of a particular cell/s.

 

[pgc01]

Hi Phil

For ex. if you want a fixed length of 10, assuming you want to left pad with spaces:

=RIGHT(REPT(" ",10)&A1,10)

 

[Stormseed]

Hi Pedro

It would never strike my mind to use REPT() !! You guys read out the possible solution in a fraction of a second

 

[hcabs99]

Perfect, works a treat, many thanks

Phil

Hi Phil

For ex. if you want a fixed length of 10, assuming you want to left pad with spaces:

=RIGHT(REPT(" ",10)&A1,10)