Adding text when using the Proper command in Excel

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
LVL 1
Bill GoldenExecutive Managing MemberAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
="1 "&Proper("A1")
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill GoldenExecutive Managing MemberAuthor Commented:
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.
0
Saqib Husain, SyedEngineerCommented:
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?
0
Bill GoldenExecutive Managing MemberAuthor Commented:
You are, of course, right!  Sometimes you get mired in getting to the solution.
Your point is well taken.  
Thanks again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.