How do I Convert Uppercase to Lowercase?

[techyguy717]

Software used, Office 2010.
My client works with excel spreadsheets, made by their headquarters.

The issue is that the values come in as such:

FIRST NAME, LAST NAME
1111 ADDRESS
CITY, STATE

They need the values as such:

First Name, Last Name
1111 Address
City, State

Headquarters is unwilling to change how they type them up.
Meanwhile my client has allocated resources to start typing them in ALL OVER AGAIN.
How do we get the values in lowercase, but with the first letter in uppercase?
I hope to be able to teach office workers an easy way to do this.

[mraikes]

Something like this?
http://misterexcel.wordpress.com/200...to-title-case/

[codegreen]

I would script it using VBA. I'm not an expert at VBA scripting, so I won't make a fool of myself offering code samples. This site might help: http://www.ozgrid.com/VBA/change-case-text.htm.

[abbasmuraj]

=proper(cell value or ranges)

['putertutor]

abbasmuraj beat me to it. proper() is probably the easiest way to get that done.

[altrenda]

As previously said, the proper function is built into excel.
Here is what I send out when asked this question.

http://www.cornerstonesolutions.com/...roper_Case.pdf

[techyguy717]

Thank you all, this works great. Just one problem still remains.
Do I need to change the value for every row?
=Proper(A2)
=Proper(A3)
=Proper(A4)

They have thousands of rows and this will still be very time consuming.

[altrenda]

Originally Posted by techyguy717

Thank you all, this works great. Just one problem still remains.
Do I need to change the value for every row?
=Proper(A2)
=Proper(A3)
=Proper(A4)

They have thousands of rows and this will still be very time consuming.

From the page I linked.

"3. Copy the formula down to apply it to the remaining rows in that column, now the new column is a proper case copy of the original data."

You do know how to copy formulas in Excel?

[Boston Pro Comp Serv LLC]

You can probably use a range = proper(A1,C3) or somthing to that effect

[techyguy717]

Thank you, altrenda and everyone else. This saved a lot of time.

I was copying the formula, but was not pasting the formula correctly.
I merely pasted.

After copying the formula I need to:

- Paste Special
- Paste as Formula