View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Constantly Amazed Constantly Amazed is offline
external usenet poster
 
Posts: 41
Default Packing characters

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