J
Josh Craig
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.
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.