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