Retrieving data from a cell

Please help with formula. I have the following in Column A

01. Artist - Title

I manage to put 01 in Column B and Title in Column D
I am struggling to split between the "." and the "-" to show Artist in Column C
I am using in Column B

Please Login or Register  to view this content.

and in Column D

Please Login or Register  to view this content.

A plethora of options in truth, one (based on your existing logic) would be:

C1: =IF(A1="","",TRIM(REPLACE(LEFT(A1,FIND("-",A1)-1),1,FIND(".",A1),"")))

Try:

Please Login or Register  to view this content.

Cheers,