View Single Post
  #2   Report Post  
Ken Hudson
 
Posts: n/a
Default How do I change lowercase data to capped data?

Hi,
With "abcd" in A1, enter "=UPPER(A1)" in B1 - no quotes. - to get "ABCD."
--
Ken Hudson


"Monique" wrote:

I have a bunch of data that I typed in lowercases in lots of cells. What can
I do to change the data to uppercase letters all at the same time? I don't
want to have to retype the data.

Thank you