software

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: www.excelforum.com/member.php...oamp;userid=26559
View this thread: www.excelforum.com/showthread...hreadid=526321Use Datagt;Text To Columns with space and - as delimiters.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Rikukquot; gt; wrote in
message ...
gt;
gt; Hi, I have a web query that pulls football league fixtures from a
gt; website, the two teams appear in one cell after the extract, is there a
gt; way of spliting the two team to individual cell.
gt;
gt; This is what its looks like when extracted.
gt;
gt; Middlesbrough - Bolton
gt; Charlton - Newcastle
gt; Man Utd - Birmingham
gt;
gt; Rik
gt;
gt;
gt; --
gt; Rikuk
gt; ------------------------------------------------------------------------
gt; Rikuk's Profile:
www.excelforum.com/member.php...oamp;userid=26559
gt; View this thread: www.excelforum.com/showthread...hreadid=526321
gt;

Thank you just what I needed.

Rik--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: www.excelforum.com/member.php...oamp;userid=26559
View this thread: www.excelforum.com/showthread...hreadid=526321
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: www.excelforum.com/member.php...oamp;userid=26559
View this thread: www.excelforum.com/showthread...hreadid=526321Try 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)

quot;Rikukquot; gt; wrote in
message ...
gt;
gt; I've manged to split the two teams into seperate cells, my VLookup fails
gt; now because there a space at the end of each team name. Can this be
gt; removed or can VLookup do a near match instead of exact match?
gt;
gt; Middlesbrough - Bolton
gt; Charlton - Newcastle
gt; Man Utd - Birmingham
gt;
gt; Rik
gt;
gt;
gt;
gt; --
gt; Rikuk
gt; ------------------------------------------------------------------------
gt; Rikuk's Profile:
www.excelforum.com/member.php...oamp;userid=26559
gt; View this thread: www.excelforum.com/showthread...hreadid=526321
gt;

Thank you fully working now

Rik--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: www.excelforum.com/member.php...oamp;userid=26559
View this thread: www.excelforum.com/showthread...hreadid=526321