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

V

VBA Noob

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

Word doc keeps changing to ALL CAPS 0
Find rows that contain capital letter? 4
How do I change text from all caps to normal type? 3
Change Lowercase or Proper to ALL CAPS 3
Converting all-caps to lowercase italics in whole doc 1
Word - 2007 2
lower case types as all caps and all caps types as lower case 4
New Emails always formatted in capital letters 1

Top