View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default In Excel, changing a range of cells to all caps.

Hi,
in another column enter

=upper(A1)

I assume that A1 is the cell where you have the text, copy formula down


"antonioejones612" wrote:

I would like to know how to change a range of cells from mixed- or lower-case
to all upper-case in Excel.