Separate words into different columns by capital letters

[plakatown]

I want to separate words into different columns once a capital letter is met as in rows 5 and 6.
But the same function does not work in rows 2 to 4.
Is there anyway to solve this? Thanks!

capital.png

The functions I use in columns C and D are
cell C2:
=LEFT(A2,SMALL(FIND(CHAR(ROW(INDIRECT("65:90"))),A2&"ABCDEFGHIJKLMNOPQRSTUVWXYZ"),2)-1)
cell D2:
=REPLACE(A2,1,LEN(C2),"")

Edit:
I figured out what's wrong.
The 2 was in the wrong place so the FIND started as 1
SMALL was missing the second argument (1).

[Glenn Kennedy]

You can also use this, which avoids the unnecessary use of the volatile INDIRECT function:

=IFERROR(MID(A1,MATCH(1,(CODE(MID(A1,ROW($1:$255),1))>=65)*(CODE(MID(A1,ROW($2:$255),1))<90),)+1,255),"")

It's still an array formula. But this variant might not be in your Excel version:

=IFERROR(MID(A2,MATCH(1,INDEX((CODE(MID(A2,ROW($1:$255),1))>=65)*(CODE(MID(A2,ROW($2:$255),1))<90),),0)+1,255),"")

and then just use SUBSTITUTE for the other word.

[plakatown]

You can also use this, which avoids the unnecessary use of the volatile INDIRECT function:

=IFERROR(MID(A1,MATCH(1,(CODE(MID(A1,ROW($1:$255),1))>=65)*(CODE(MID(A1,ROW($2:$255),1))<90),)+1,255),"")

It's still an array formula. But this variant might not be in your Excel version:

=IFERROR(MID(A2,MATCH(1,INDEX((CODE(MID(A2,ROW($1:$255),1))>=65)*(CODE(MID(A2,ROW($2:$255),1))<90),),0)+1,255),"")

and then just use SUBSTITUTE for the other word.

Thank you for the additional solution!