| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help needed - creating invoice from packing list (both in excel) | Excel Discussion (Misc queries) | |||
| Named Ranges - what characters are (or are not) allowed in the nam | Excel Discussion (Misc queries) | |||
| How can I control the length of characters a code will return? | Excel Discussion (Misc queries) | |||
| Formula to replace invalid filename characters | Excel Worksheet Functions | |||
| Help - Can't directly input Japanese characters into cell | Excel Discussion (Misc queries) | |||
Threaded Mode
