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

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

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

"CT Cameron" <CT wrote ...
How do I change existing text in lower case to upper case

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

--
Don Guillett
SalesAid Software

"CT Cameron" <CT wrote in message
...
How do I change existing text in lower case to upper case