uppercase to lowercase

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

Guest

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?
 
=PROPER(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Excel - stop automatically changing mixture of uppercase and lowercase to propercase 2
Filtering on upper/lowercase letters 2
Case Sensative Subtotaling 3
Find the UPPERCASE letter in a string 9
search for any lowercase immediately followed by an UPPERCASE 9
uppercase to lowercase 4
Excel Macro 7
convert a range of lowercase text to upper text or vice versa 2

Back
Top