How do I change existing text from lower case to upper case

[CT Cameron]

How do I change existing text in lower case to upper case

 

[David McRitchie]

same as your previous question, if the duplication was on purpose
it is a waste of everyone's time involved including your own.
http://www.mvps.org/dmcritchie/excel/proper.htm#upper

 

[Don Guillett]

formula
=upper(a1)
macro
range("a1")=ucase(range("a1"))