<div>
Thanks. &nbsp;That will do the trick. &nbsp;It also solves my earlier dilemma. &nbsp;Now I can do a F&amp;R and replace the number with spaces.
</div>


Thanks.  That will do the trick.  It also solves my earlier dilemma.  Now I can do a F&R and replace the number with spaces.

<div>
I have a feeling you are complicating things. Why would you have to do a find and replace? Why don't you put what you want in the first instance?
</div>


I have a feeling you are complicating things. Why would you have to do a find and replace? Why don't you put what you want in the first instance?

<div>
You are, of course, right! &nbsp;Sometimes you get mired in getting to the solution.<br />
Your point is well taken. &nbsp;<br />
Thanks again.
</div>


You are, of course, right!  Sometimes you get mired in getting to the solution.
Your point is well taken.  
Thanks again.

<div>
<div class="content wysiwyg-content">
I have twenty pages of reports where the Account Names are all Caps and Indented. &nbsp;<br />
<br />
In A1 I have the following text:<br />
ADMINISTRATIVE EXPENSES<br />
<br />
I am putting the following formula in B1:<br />
=Proper(&quot;A1&quot;)<br />
<br />
Which yields:<br />
Administrative Expenses<br />
<br />
HOWEVER I was to add the number 1 in front of the subsequent text as follows:<br />
<br />
1Administrative Expenses<br />
or <br />
1 Administrative Expenses
</div>
</div>


I have twenty pages of reports where the Account Names are all Caps and Indented.  

In A1 I have the following text:
ADMINISTRATIVE EXPENSES

I am putting the following formula in B1:
=Proper("A1")

Which yields:
Administrative Expenses

HOWEVER I was to add the number 1 in front of the subsequent text as follows:

1Administrative Expenses
or 
1 Administrative Expenses

Adding text when using the Proper command in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.