Hi Experts out there

Have tried formulas to try and separate whole names but to messy fails to often for me anyway

Vba needed i believe

Issues Are


Name lengths vary

Names tripple, quadruple barreled

Names can have apostrophes

String order can alter - (Always only on the 2nd name though (Blue))

Example : Usually is like below

$4.20 Down Here Up There, $5.50 Libetto,

Then can alter to

$4.20 Down Here Up There, Libetto, $5.50,

See Race4 Of Attachment (If you like)



All are Separate Races 25 mins apart
Line of Concern Lands On B19 Sheet1


Thanks in Advance to Experts

Kind Regards and respect

Mike : )