Indent Function

**mkvassh** · 05-16-2010, 10:04 AM

I'm looking for an UDF Indent Function. There is one in the link below, but this is not true Indent. It is spaces before the text. Any suggestions?

http://www.excelforum.com/excel-gene...-function.html

**pb71** · 05-16-2010, 11:00 AM

What are you trying to achieve with the Indent. Would you want to apply different levels of indents based on cell criteria/formatting? Would a macro using the InsertIndent method in VBA meet your requirements?

**contaminated** · 05-16-2010, 11:07 AM

Hi
Don't know if u like it but u can use this function
=IF(ISNUMBER(A1),B1,CONCATENATE(REPT(" ",10),B1))

See attached for more info...

**squiggler47** · 05-16-2010, 12:01 PM

Excel wont allow a "True Indent" as indenting generally uses tab, which cells wont accept :-

=REPT(CHAR(9),4)&"TEXT"

char 9 is the tab character, so the only way to emulate is to use spaces as in the udf you referenced

**mkvassh** · 05-16-2010, 12:26 PM

OK. Thank you

**shg** · 05-16-2010, 01:48 PM

Try this. E.g.,

=SetIndent(A1, B1), where A1 is the cell to be indented, and B1 contains the indent level.

Please Login or Register  to view this content.

**gogetthemoney** · 02-12-2013, 04:10 PM

Holy cow this works unbelievably well.

**eriel.ramos** · 05-09-2014, 04:37 PM

This is a great function! Thanks.

Just a note on behavior: the formula is placed parallel to the cell with the original text, and when recalc'ed, actually modifies the original text.