I had a bit of a look but couldn't find an answer to this question:

How do I go about separating text into columns using a capital letter as the
delimiter?

For example:

So 'JoshCraig' in A1 becomes 'Josh' in A1 and 'Craig' in B1.

The problem arises because my data doesn't have spaces between first and
last names.