I've got a spreadsheet that has a few names as all "CAPS" and a few that are "Regular". Can I make all the names go from ANDREW to Andrew?
I've got a spreadsheet that has a few names as all "CAPS" and a few that are "Regular". Can I make all the names go from ANDREW to Andrew?
=Proper(A1)
A1="ANDREW"
Try this...
A1 = ANDREW
This formula entered in B1:
=PROPER(A1)
A2 = ANDREW JACKSON
=PROPER(A2) result = Andrew Jackson
It will capitalize the first letter of each word.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks