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


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