How to extract and split 1 cell content into 2 cells

hello,
I'd like to convert the following cell containg the following text:

01. Adam F & Kokiri Fe. Rae ‘Harmony’ (Kideko & George Kwali Radio)

so the source entry would be located in cell A1 and the export would be located at B1 and B3, split into 2 cells:
1st cell:
Adam F & Kokiri Fe. Rae
2nd cell:
Harmony (Kideko & George Kwali Radio)

what the function should do is:
1. remove the numbers and space at the beginning.
2. split the part that starts after the first '
3. discard both ' key

another 2 examples:
21. Wstrn ‘Social’
split into 2 cells:
1st:
Wstrn
2nd:
Social

16. MNEK ‘At Night (I Think About You)’ (Subside Remix)
split into 2 cells:
1st:
MNEK
2nd:
At Night (I Think About You) (Subside Remix)

Please help me with this. What's the needed formula?

Regards,

Hello,

For the first part try the following

=TRIM(MID(A1,FIND(".",A1,1)+1,FIND("‘",A1,1)-FIND(".",A1,1)-1))

First part

=TRIM(MID(A1,FIND(" ",A1),FIND("‘",A1)-FIND(" ",A1)))

Second part

=SUBSTITUTE(MID(A1,FIND("‘",A1)+1,LEN(A1)),"’","")

For the Second Party Try

=MID(A1,FIND("‘",A1,1)+1,LEN(A1)-FIND("‘",A1,1))

Later you can find and replace the " ‘ " using find and replace option in excel.

WOW Thanks guys what an awesome forum

Super fast replies

jason.b75 got it right thanks a lot

thanks zaska as well (the 1st ' key was not removed in your formula but thanks a lot man)