Indent Function

[enimen]

Hello Folks,

Why is there a function(formula) for Indenting text in Excel? I would like to convert certain text into different levels as per their deparment

Finance
John Smith
Katie Curic

Accounting
Celina Woodpecker
Masha Yukovic


into

Finance

John Smith

Katie Curic

Accounting

Celina Woodpecker

Masha Yukovic

Is it not possible to do it for multiple worksheets quickly? I would want to create a function that would

=INDENT(A1,1) meaning indent once
=INDENT(A2,2) meaning indent twice

that will be great for my excel reports!!
Please help!!!

[mrice]

Try this user defined function

Please Login or Register  to view this content.

It works best with a non-proportionate font such as Courier New.

[enimen]

This completely works!

Thanks, mrice, really appreciate it!

[ChemistB]

Word of caution: Be careful if you later plan to manipulate, lookup or use numbers after using this macro. You'll need to TRIM or otherwise fix things because it's not a true indent, it's placing blank spaces before your text.

ChemistB

[enimen]

I understand and thanks for the heads-up - This formula just helped me remove the CONCATENATE FORMULA
=IF(C2="","",IF(L2=7,CONCATENATE(" SPACES ",C2),IF(L2=8,CONCATENATE(" MORE SPACES ",C2)


so its not a long formula. I wonder why we can't create

First Level
Indent.Level 1

Second Level
Indent.Level 1
Indent.Level 1

or something with the code. I wonder why we don't have Indent Function the way Mrice created it =INDENT(A1,1), etc.. to begin with

[mrice]

I did try the use of chr$(9) instead of the spaces to insert a tab but this didn't appear to work.

[Richard Buttrey]

Hi,

I don't see the real problem here. Why not just use the

Please Login or Register  to view this content.

instruction in a macro, where n = a numeric variable that determines how many indent spaces you need and myrange is the cell/cells you're interested in.

HTH

[shg]

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