View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Making all text become lower case

Have you tried the Lower function...

=Lower(A1)
--
HTH...

Jim Thomlinson


"amik" wrote:

I have a column of info with text and numbers.

Is there a way to make all the text become lowercase?

Thanks,

Adam