Text Split
You have more responses at your other post.
DDay wrote:
Hi,
I have 4000 line of data which is first and surnames combined e.g DavidHill,
MarkSmith etc etc. I need a formula to divide these by the second capital
letter only to make David Hill, Mark Smith etc etc
All entries have a capital letter at the start of the forename and surname,
thanks
--
Dave Peterson
|