Looking for a formula that will capitalize the first letter of the first word in a cell and make all subsequent words lower case. So say I have a cell that reads: "Mike Drinks A Lot of Coffee", I want it to look like "Mike drinks a lot of coffee". Does this make sense? Any help is greatly appreciated.
Try this
Formula:
Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
Last edited by Marcol; 01-18-2013 at 10:29 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Here's another one...
=REPLACE(LOWER(A2),1,1,UPPER(LEFT(A2)))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
If the first letter of the string will always be in uppercase then we can reduce that to:Originally Posted by Tony Valko
=REPLACE(LOWER(A2),1,1,LEFT(A2))
This is good, one other thing. If I have words separated by a comma, I want the first word followed by the comma to have it's first letter capitalized. Any way to add that to this formula?
Seperated with a comma, or a comma folowed by a space?
How many comma seperated words/phrases?
Best post a sample workbook.
Last edited by Marcol; 01-18-2013 at 03:09 PM. Reason: typo
here ya go, hopefully this conveys my problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks