Extract names before and after a /

[S.H.A.D.O.]

Good evening,

I am an avid darts fan and keep a spreadsheet of the different tornaments.
Now when the draw is shown on the Internet it is the format...

Rob Cross (3) v Steve Lennon/Rowby-John Rodriguez
John Henderson (14) v James Richardson/Jason Cullen
Mensur Suljovic (6) v Josh Payne/Jonny Clayton
Simon Whitlock (11) v Jan Dekker/Adrian Lewis
Joe Cullen (7) v Adam Huckvale/Jermaine Wattimena
Kim Huybrechts (10) v Wayne Jones/Jamie Lewis
Peter Wright (2) v Johan Engstrom/James Wilson
Gerwyn Price (15) v Toni Alcinas/Dragutin Horvat
Michael Smith (4) v Tobias Mueller/Stephen Bunting
Jelle Klaasen (13) v Ricky Evans/Krzysztof Ratajski
Daryl Gurney (5) v James Wade/Cristo Reyes
Mervyn King (12) v Ryan Joyce/Michael Rosenauer
Dave Chisnall (8) v Cameron Menzies/Kevin Munch
Ian White (9) v Christian Kist/Kyle Anderson
Michael van Gerwen (1) v Mike De Decker/Terry Jenkins
Darren Webster (16) v Jeffrey de Graaf/Steve Beaton

...for example.

What I want to be able to do is to split all the names into different columns please.

To split the name on the left I have come up with this formula:

=LEFT(A1,FIND(")",A1,1)*1)

To split the name to the right of the slash I have come up with this formula:

=MID(A1,FIND("/",A1)+1,9999)

But I can't seem to get it to do the name in the middle.

Any help will be greatly appreciated.

Thanks in advance.

 

[S.H.A.D.O.]

I would like to thank everyone for their time and input, it is very much appreciated.

I am going to go with Peter_SSs all in one formula which does exactly what I want it to do.

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1," v ","/"),"/",REPT(" ",100)),COLUMNS($B:B)*100-99,100))

I like the code Rick Rothstein, it's short, compact and it does exactly what it says on the tin.

One question please Rick Rothstein, I ran Sektor's code and nothing appeared to happen. You mention not using the RegExp macro, has this done anything to my computer and can I undo it please?

Thanks in advance.

 

[Rick Rothstein]

One question please Rick Rothstein, I ran Sektor's code and nothing appeared to happen. You mention not using the RegExp macro, has this done anything to my computer and can I undo it please?

His code doesn't do anything other than load up three variable and then the macro ends. I think he was assuming only one cell had data in it and the OP would add code at the end of the macro to do something with the three variables.

 

[S.H.A.D.O.]

Thanks for the clarification Rick Rothstein, I appreciate it. Have a great weekend.

 

[Peter_SSs]

I would like to thank everyone for their time and input, it is very much appreciated.

I am going to go with Peter_SSs all in one formula which does exactly what I want it to do.

You are very welcome. Glad it helped.

 

[jtakw]

I would like to thank everyone for their time and input, it is very much appreciated.

You're welcome, glad to help.
@Peter_SSs, yeah, I was at a friend's place using an antique computer with a lot of distractions, looking back at my formula, I don't know why I used a couple of Extra SUBSTITUTEs, thanks for shortening it for me.