Formula to split cell data

[paulwebb]

Hi all

I have a spreadsheet which imports data from a web page. The data is football fixtures, which are imported as 1 fixture per cell e.g. "Liverpool v Manchester United". The teams are always separated by (space)v(space). Is there a simple formula I can use that will extract the teams to individual cells, so that if the fixture was in say cell A1, I could import the home team to cell B1 and the away team to cell C1? I'm sure I did something like this a long time ago, but the old grey matter isn't as sharp as it used to be!

Thanks in anticipation

Paul

 

[circledchicken]

Hi,

This should do it:

In cell B1: =LEFT(A1,SEARCH(" v ",A1,1)-1)
In cell C1: =RIGHT(A1,LEN(A1)-SEARCH(" v ",A1,1)-2)

 

[paulwebb]

Hi,

This should do it:

In cell B1: =LEFT(A1,SEARCH(" v ",A1,1)-1)
In cell C1: =RIGHT(A1,LEN(A1)-SEARCH(" v ",A1,1)-2)

Brilliant, does the job perfectly, thank you very much

Paul

 

[circledchicken]

Your very welcome...