I have twenty pages of reports where the Account Names are all Caps and Indented.
In A1 I have the following text:
I am putting the following formula in B1:
HOWEVER I was to add the number 1 in front of the subsequent text as follows:
1 Administrative Expenses