Thread: change text case in excel without using formula like word?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default change text case in excel without using formula like word?


shahid into Shahid or SHAHID or sHAHID
=PROPER(A11) =UPPER(A11)
=LOWER(LEFT(A11))&UPPER(MID(A11,2,LEN(A11)))


Regards,
Stefi



help me how we can do.

reply me at.

Shahid Ghafoor Mughal


Reply With QuoteReply With Quote