Thread: Chg existing cells fr Proper to Upper w/o re-typing.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SteveG
 
Posts: n/a
Default Chg existing cells fr Proper to Upper w/o re-typing.

You can use the UPPER function.

=UPPER(A1) where your text is in A1. Copy down as needed.


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=515958

Reply With QuoteReply With Quote