Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=526321 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=526321 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showing the contents of a cell based on another cell | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions |