View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alicia Alicia is offline
external usenet poster
 
Posts: 34
Default convert to upper case - entire column ?

I have a column of names and would like to do a data conversion
from lower case to upper case. I know the formula is =upper(" ")
but is there a way to have it do the conversion for an entire column at once.
Don't know what I am doing wrong but it seems I have to enter it in each
cell which is not exactly a time saver......

Any suggestions? Thanks.

Alicia