How do I split a word based on the capital letters

This will only work on 2 word names.

Create this named formula.
Name: Letters
Refers to: =CHAR(ROW(INDIRECT("65:90")))

Then...

Data Range

	A	B	C
1	Combined	First	Last
2	SamSmith	Sam	Smith
3	RohitSingh	Rohit	Singh
4	BobRobertson	Bob	Robertson
5	GeneGerace	Gene	Gerace
6	LindaCabana	Linda	Cabana

Enter this array formula** in B2:

=LEFT(A2,MIN(FIND(Letters,A2&Letters,2))-1)

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Enter this formula in C2:

=MID(A2,LEN(B2)+1,20)

Select B2:C2 and copy down as needed.