=REPLACE(A1,MAX(IF(ISERROR(FIND(CHAR(ROW(INDIRECT( "65:90"))),A1)),"",FIND(CHAR(ROW(INDIRECT("65:90") )),A1))),0," ")

ctrl+shift+enter, not just enter


"xlmate" wrote:

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