Split data in single cell

[jwp]

Hi

I am so close but am struggling can someone help complete my code.

I have the following in a single cell there are 2 posibilities the data is either split by " v " or a " - " I want the data split by these 2 posible characters and put into 2 cells.

Sample Data in 1 cell

Joe Bloggs v Fred Flinstone
Jeremy Clarkson - The Stig

I want this in 2 cells like
Joe Bloggs
Fred Flinstone

or
Jeremy Clarkson
The Stig


My code so far is working to split the first name with v or - but I can only paste the first name into a cell.

x=split(cell.offset(1,0), " v ")
Sheets("Temp").Range("A1") = x

Thank you for any help provided

 

[mikerickson]

Actualy, I noticed that mine would fail with David v Goliath. Try merging the two

X = Split(Replace(Cell.Offset(1, 0), " - ", " v ") & " v ", " v ")
Range("B1").Value = X(0)
Range("B2").Value = X(1)

 

[jwp]

You the man that works a treat.

Thank you for spending the time to get that right for me.