Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Missy
 
Posts: n/a
Default uppercase to lowercase

Please tell me how to change all uppercase to first letter only uppercase,
JOHN DOE to John Doe. Can I do a whole worksheet in one try?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=PROPER(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Missy" wrote in message
...
Please tell me how to change all uppercase to first letter only uppercase,
JOHN DOE to John Doe. Can I do a whole worksheet in one try?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change certain cells to Uppercase TazDevil Excel Worksheet Functions 4 August 1st 05 06:35 AM
lowercase to uppercase Louise Excel Worksheet Functions 6 January 10th 05 09:41 PM
uppercase to lowercase Mammoth Excel Discussion (Misc queries) 3 November 28th 04 03:19 AM
Uppercase in a whole sheet Manu Palao Excel Worksheet Functions 4 November 18th 04 01:11 AM
How to change text in multiple cells from Uppercase to proper cas. Excel help Excel Worksheet Functions 1 November 17th 04 03:45 AM


All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"