Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula is needed to return the number of spaces indented?
|
#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 |
Reply |
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 |