Sunday, May 24, 2009
UPPERCASE to Title Case
How to change your UPPERCASE words with Title Case ?
HINT
: Use PROPER() function on Excel
Example
: MICHAEL JACKSON become Michael Jackson
Step 01:
I wrote "MICHAEL JACKSON" on cell B2
Step 02
:
I move my cursor to cell D2 then write "=Proper(B2)" then press Enter
The Result:
4 comments:
Anonymous
June 19, 2009 at 8:07 AM
Thanks!
Reply
Delete
Replies
Reply
mas
August 17, 2009 at 1:44 AM
good thank you
Reply
Delete
Replies
Reply
Wenghan
July 15, 2013 at 8:04 PM
This is a great help. Thanks!
Reply
Delete
Replies
Reply
Anonymous
August 2, 2013 at 5:19 AM
brilliant thanks!
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
▼
2009
(21)
▼
May
(15)
Install Add-Ins
Creating Chart in Excel 2007
UPPERCASE to Title Case
Using Conditional Formatting
Create Drop down List
Clear Recent Files
Linear Regression with Excel
Phone Number format
Show Developer tab
Insert Symbol
Change Horizontal Axis chart
Create Chart with Fast
Subtotal your values
Open your 2007 excel files on Excel 2003
Change Excel Color Scheme (Skin Color)
►
June
(6)
Visitor
Feedjit Live Blog Stats
Thanks!
ReplyDeletegood thank you
ReplyDeleteThis is a great help. Thanks!
ReplyDeletebrilliant thanks!
ReplyDelete