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!!!