How to make Upper Case in every word in a Cell

[karinos57]

How can i convert into upper case every word in a given cell. For instance:
I have the following in column A:
books pen desk
i want it to be like this:
Books Pen Desk
Thanks for your time.

[shg]

How about just a formula: =Proper(A1)

[davesexcel]

I believe what you are asking for is Proper Case not Upper Case.
Try

Please Login or Register  to view this content.

Running the above code will convert Column A to Proper Case




This should automatically set the text to proper case when you enter text into a cell

Please Login or Register  to view this content.

[karinos57]

This is what i need. Thanks a lot