Split contents of a cell

[Rikuk]

Hi, I have a web query that pulls football league fixtures from a
website, the two teams appear in one cell after the extract, is there a
way of spliting the two team to individual cell.

This is what its looks like when extracted.

Middlesbrough - Bolton
Charlton - Newcastle
Man Utd - Birmingham

Rik

 

[Dennis]

Try selecting all and format the text to Courier. Then Data|Text to Columns
and follow the wizard.

HTH, Dennis
===============

 

[Bob Phillips]

Use Data>Text To Columns with space and - as delimiters.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Rikuk]

Thank you just what I needed.

Rik

 

[Rikuk]

I've manged to split the two teams into seperate cells, my VLookup fails
now because there a space at the end of each team name. Can this be
removed or can VLookup do a near match instead of exact match?

Middlesbrough - Bolton
Charlton - Newcastle
Man Utd - Birmingham

Rik

 

[Bob Phillips]

Try trimming the lookup value, like this

=VLOOKUP(TRIM(A2),I2:K45,2,FALSE)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Rikuk]

Thank you fully working now

Rik