ExcelBanter - What formula is needed to return the number of spaces indented?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What formula is needed to return the number of spaces indented? (https://www.excelbanter.com/excel-worksheet-functions/253127-what-formula-needed-return-number-spaces-indented.html)

INDENT

What formula is needed to return the number of spaces indented?

Dave Peterson

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

All times are GMT +1. The time now is 10:24 PM.