How do I change the case in Excel Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have ready the posts regarding this subject. I'm an idiot evidentally.
Actually, i've never done this before.

I've tried entering the =PROPER(text) formula, nothing happens. I've tried
copying to VBA (which I don't even know what any of this means) nothing
happens. What is the quickest way to find a step by step solution for
DUMMIES?????
 
The PROPER() function changes the first letter to upper case, and
leaves the rest as lower case. Try using UPPER(text) and see if that
works. If it doesn't, please post back with examples so we can
troubleshoot with you.
 
Minor clarification:
The PROPER() function changes the first letter to upper case
should read as
The PROPER() function changes the first letter of each word in the text
string to upper case
 
Assuming you have text in A1 like john smith

In B1 enter =PROPER(A1)

Returns John Smith


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change case 4
How to subtract a number from a Mergefield? 0
GOG - 2 step verification e-mail not received 4
How do I change the timezones in excel spreadsheets? 2
PowerPoint Super Stuck and Desperately Need Help 0
Newly opened spreadsheet doesn't display in Excel 2007 2
How do I open a spreadsheet? 6
Formula in Excel does not work until after I double-click inside c 7

Back
Top