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

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

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

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

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

You've got another replay at your other post.

Please don't multipost.

Don wrote:

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

--

Dave Peterson