extract text between 2 different characters

[Grahamfeeley]

Hi I cant seem to get this formula right, being trying hard enough....

in column A starting A2 i have a lot of rows of data such as this in the attachment

I wish to extract 4 columns data starting in B2 which I have solvedthe first column in B2
But I am stuck with rest of extraction which involves the Mid function
as I said I got B2 solved

I managed to extract the first extraction which has column header Horse
But I cant solve the rest of the formulas for racno, Track and tabno
Any help will be greatly welcome
Graham

[Bo_Ry]

Please try at
C2
=TRIM(MID(A2,FIND("""",A2)+1,3))

D2
=PROPER(TRIM(LEFT(SUBSTITUTE(MID(A2,FIND("-",A2)+2,50),"""",REPT(" ",50)),50)))

E2
=-LOOKUP(0,-MID(A2,SEARCH(D2,A2)+3+LEN(D2),{1,2,3}))

or the same formula from B:E

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"""",),"-",","),",",REPT(" ",99)),COLUMNS($B2:B2)*99-98,99))

[jindon]

Try

Please Login or Register  to view this content.

[karedog]

Another one :

Please Login or Register  to view this content.

[Grahamfeeley]

Jindon code stops on line 6, however it has been solved abd I always appreciate your help
Regards
Graham