Is there a way to change Lowercase or Proper to ALL CAPS?

  • Thread starter Thread starter Don
  • Start date Start date
Hi,

If your data starts in A1 enter this in B1

=Upper(A1)

and drag down as required.

To keep the values select column B and then paste special values

VBA Noob
 

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 Lowercase or Proper to ALL CAPS 3
How do I change text from all caps to normal type? 3
Converting all-caps to lowercase italics in whole doc 1
Excel - stop automatically changing mixture of uppercase and lowercase to propercase 2
Word - 2007 2
Case formula? 3
Init Caps 2
lowercase to caps 1

Back
Top