How do I convert text to uppercase?

B

bb3000ma

How do I convert all text in an existing Excel sheet that contains both upper
and lower case letters?
 
S

SilverM78

If a1 is upper then =upper(a1) will return ( UPPER)
=lower will return all lower case
=proper will capitalize first letter of each wor
 
Top