How to create column with delimated rules

[MartMoney]

Hi, i'm quite new to excel and i have a difficult task to accomplish.
I have a column with this text :

Funkash (Version 2) 6A
Attack! Attack! (Lorenz & Kristoph Rmx) 5A
Fly Away (Martin Eyerer Rmx) 7B
Generate (Original Mix) 8A
My Beach (Original Mix) 10A
Phat Laces (Original Mix) 9A
Problem Is (Soul of Man Remix) 8A
Skipper (Original Mix) 5A/8A

My problem is: I would like to create a column for each of these
values (TRACK NAME) (REMIX) (CHORD VALUE)

As you can see for the example above, the first song :
TRACK NAME = Funkash
REMIX = Version 2
CHORD VALUE = 6A

Between the (TRACK NAME) and (REMIX) i have 1 space.
Between the (REMIX) and (CHORD VALUE) i have 2 spaces.

What is the function in excel to split this one cell value into 3
cells containing those 3 values.
Thanks to explain!

 

[JE McGimpsey]

What is the function in excel to split this one cell value into 3
cells containing those 3 values.
Thanks to explain!

One way (not using functions):

Select column A. Choose Data/Text to columns. Select the Delimited radio
button and click Next. Check the Other checkbox and enter "(" (no
quotes). Click Finish.

Now select column B. Do the same thing, except use ")".

If you MUST use functions:

B1: =TRIM(LEFT(A1,FIND("(",A1)-1))
C1: =MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,255)
D1: =TRIM(MID(A1,FIND(")",A1)+1,255))