View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How do convert an entire column of text in Excel to all caps?

Assuming that your existing name is in column A, use the following
function:

=UPPER(A1)