Thread: HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave R.
 
Posts: n/a
Default HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?
use =UPPER(A1) in a helper cell then copy over the originals by pasting
values.

"daveylee" wrote in message
...
I have a spread sheet with company, name and tel columns. I need to
convert
the Company column to all caps. ???


Reply With QuoteReply With Quote