| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula is needed to return the number of spaces indented?
How did you do the indenting?
If you just typed leading spaces... =search(left(trim(a1),1),a1)-1 INDENT wrote: -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to convert a number with spaces to just a number? | Excel Discussion (Misc queries) | |||
| Formula Needed - Truncate extra spaces at end of variable text len | Excel Discussion (Misc queries) | |||
| need result of formula to compare itself to another number andincrease if needed. | Excel Discussion (Misc queries) | |||
| Replace double spaces with Hard return | Excel Worksheet Functions | |||
| Formula Needed to Compare Dates and return a running total | Excel Worksheet Functions | |||
Threaded Mode
