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


Don wrote:
Is there a way to change Lowercase or Proper to ALL CAPS?
Thanks,
Don