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



Array formula (commit with CTRL+SHIFT+ENTER):

=LEFT(A1,MATCH(0,--EXACT(MID(A1,ROW(2:99),1),
MID(LOWER(A1),ROW(2:99),1)),0))&" "&
MID(A1,MATCH(0,--EXACT(MID(A1,ROW(2:99),1),
MID(LOWER(A1),ROW(2:99),1)),0)+1,LEN(A1))