Packing characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Roger

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

G
 
Hi,

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

HTH,
Bernd
 
You must log in or register to reply here.

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

Excel Subtract text after the third space and before the fourth (from between spaces) 3
What excel snyntax and or function will add leading spaces 3
Adding recognised Zeros 5
Concatenating two variable fields into a static length text field 2
Adding Spaces to the end of a value 4
Remove Characters Until a Specific Character is Reached 7
HOW CAN I EXTRACT TEXT TO THE RIGHT OF A THIRD SPACE FROM THE LEFT 11
Find position number of third space 6

Back
Top