| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell lenght MUST be always 30
eHello:
I need to always have 30 char in a given cell, if the original string is less than 30 chars, lets say 23 then I need to fill in at the right of the string with 7 blank spaces. The original string lenght may vary from 1 to 30. Is there a formula or VBA code to do this? Any and all help would be highly appreciated! PLK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max Formula Lenght | Excel Discussion (Misc queries) | |||
| fixed cell lenght | Excel Discussion (Misc queries) | |||
| Lenght of sheets | Excel Worksheet Functions | |||
| lenght of status bar | Excel Discussion (Misc queries) | |||
| Calculating a sum of various lenght | Excel Worksheet Functions | |||
Threaded Mode
