Thread: Changing uppercase to lowercase
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SamuelT SamuelT is offline
external usenet poster
  
Posts: 1
Default Changing uppercase to lowercase

Hi,

Instead of fiddling with VBA, why don't you just do:

=LOWER(A1)

This'll change all the text to lowercase. You'll need to do it in a
seperate column, but then just copy and paste it over.

HTH,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=573001

Reply With QuoteReply With Quote