| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I query the 'indent' level of text in a cell?
This is part of the format - cell - alignment setup.
There are many things that can be queried using an Excel function. But how can I query the indent level? I have tried/search for hours...please help! Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I query the 'indent' level of text in a cell?
Activecell.IndentLevel
-- Jim "NJDevil" wrote in message ... This is part of the format - cell - alignment setup. There are many things that can be queried using an Excel function. But how can I query the indent level? I have tried/search for hours...please help! Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I query the 'indent' level of text in a cell?
How about
Len(yourcell) - Trim(yourcell) The result would be the number of leading spaces provided you have no other irregular spacing in the cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use conditional formatting to set text height and indent. | New Users to Excel | |||
| Indent text in cell | Excel Discussion (Misc queries) | |||
| INDENT TEXT IN A CELL | Excel Discussion (Misc queries) | |||
| Filter text in a column by its Indent, to remove certain text | Excel Discussion (Misc queries) | |||
| Two level web query? | Excel Programming | |||
Hybrid Mode
