extract data from left and right

[pallet48]

hello,

i wish to extract data from left and right eg 7/2Middlesbrough to 7/2 and Middlesbrough in separate columns , i have enclosed the data in

a spreadsheet, the numbers vary as does the names

any help greatly appreciated

Cheers

Stu

[Special-K]

Try this

in B1
=MID(A1,MIN(FIND({"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"R";"S";"T";"U";"V";"W";"X";"Y";"Z"},A1&
"ABCDEFGHIJKLMNOPQRSTUVWXYZ",1)),1000)

Source: http://www.pcreview.co.uk/forums/fin...-t1745981.html

in C1
=LEFT(A1,FIND(B1,A1)-1)

[TMS]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards, TMS

[Special-K]

@TMS

That won't work if the divisor is more than one digit long, e.g. the odds are 13/12

[pallet48]

cheers mate, stu

in B1
=MID(A1,MIN(FIND({"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"R";"S";"T";"U";"V";"W";"X";"Y";"Z"},A1&
"ABCDEFGHIJKLMNOPQRSTUVWXYZ",1)),1000)

Source: http://www.pcreview.co.uk/forums/fin...-t1745981.html

in C1
=LEFT(A1,FIND(B1,A1)-1)[/QUOTE]

[samba_ravi]

B1=LEFT(A1,LOOKUP(65,CODE(MID(A1,ROW($1:$256),1)),ROW($1:$256)))
C1=SUBSTITUTE(A1,B1,"")
Try this