View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xlmate xlmate is offline
external usenet poster
 
Posts: 144
Default Parse A String into Two

I can't remember how do I separate the text into two
by finding the 2nd upeer case.

eg SmithJohn to Smith John

--

Appreciate your help.


Thank You

cheers, francis