| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What excel snyntax and or function will add leading spaces
I have a requirement to have meet a specified field length. For example if
name field length is 7 and the name entered is SAM; what functions (operations, marcos, vb scripts) are available in excel that can automatically add either leading or trailing spaces to make the length equal to 7? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove leading spaces | Excel Worksheet Functions | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| How keep Leading/Trailing spaces when save in Excel? | Excel Discussion (Misc queries) | |||
| How do I add leading spaces to a value? | Excel Worksheet Functions | |||
| Remove Leading Spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
