Split contents of a cell
 

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 :confused:


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526321

Split contents of a cell
 

Use DataText To Columns with space and - as delimiters.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rikuk" wrote in
message ...

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 :confused:


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile:
http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526321

Split contents of a cell
 

Thank you just what I needed.

Rik:)


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526321

Split contents of a cell
 

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
:)


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526321

Split contents of a cell
 

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" wrote in
message ...

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
:)


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile:
http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526321

Split contents of a cell
 

Thank you fully working now :)

Rik


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=526321