View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kevin Vaughn
 
Posts: n/a
Default How to change mixed case to upper case in Excel for all cells

You're welcome.
--
Kevin Vaughn


"WordAlone Network" wrote:

Thanks - that will work just fine!
Anne

"Kevin Vaughn" wrote:

You could use a helper column and the formula =upper(a1) copied down.
If you wanted, you could then copy - paste special values back over the
originals and get rid of the helper column.
--
Kevin Vaughn


"WordAlone Network" wrote:

I need to change name and address from mixed case to uppercase in the cells
on my Excel spreadsheet - is there a way to do this without retyping
everything?