Text Split
Thanks guys,
really helpful!
"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
|