| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Custom Fields with spaces
=REPLACE(REPT(" ",30),1,LEN(A1),A1)
... =A1&REPT(" ",MAX(0,30-LEN(A1))) Okay, that is another way to do it. My guess is that if we keep trying, there are probably a few other ways to accomplish this. Are you proposing that your formula is the better one to use for some reason (perhaps, it's more efficient or faster)? It's shorter. It may be more efficient, depending on how REPLACE works vs concatenation. Shorter... OK, I can buy that. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Query sometimes adds trailing spaces to fields | Excel Discussion (Misc queries) | |||
| File/custom Property fields | Excel Discussion (Misc queries) | |||
| Add spaces for specific fields to paste in | Excel Discussion (Misc queries) | |||
| Custom Format alphanumberic value with spaces | Excel Worksheet Functions | |||
| Pivot tables - custom fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
