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
 
Top