Packing characters

C

Constantly Amazed

Hi

I have an exercises where I have a list of different names, of different
lengths but I want a result which packs out the name with trailing spaces so
that the final length of the name and spaces always equals 15 for each.

ie john needs 11 spaces added to it for the length to be 15 but andrew needs
9 spaces added.

Thanks

G
 
C

Constantly Amazed

Hi Roger

Thanks that works just fine and has saved me a good deal of time.

G
 
B

bplumhoff

Hi,

Just append 15 blanks to your text and take leftmost 15 characters:
=LEFT(A1&REPT(" ",15),15)

HTH,
Bernd
 
Top