Text Extractions From String (Tricky One)

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 : )

Is this how you wanted?

Please Login or Register  to view this content.

Great so far cheers

Really just need the first 3 names if thats ok : )

Would adjust it myself if i could : )

Thanks Jindon

Then change one line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Awesome thanks alot

Kudos to you my man : ) Perfect !

You doing good things for the world

Cheers

Mike : )