Text Seperator

[Sheepkin_Coat]

I want to extract text from cell A into cell B, have tried text to columns option, but the names in A are not in a straight line, so cannot use fixed length and when i use the delimited option i don't want spaces.

i have got the latest football fixtures and they are like this


Saturday, 09 August 2008
Birmingham v Sheff Utd, 15:00
Blackpool v Bristol City, 15:00
Cardiff v Southampton, 15:00
Charlton v Swansea, 15:00
Coventry v Norwich, 15:00
Crystal Palace v Watford, 15:00
Derby v Doncaster, 15:00
Ipswich v Preston, 15:00
Nottm Forest v Reading, 15:00
Plymouth v Wolverhampton, 15:00
QPR v Barnsley, 15:00
Sheff Wed v Burnley, 15:00

i want to be able to put the away team in cell B, how can i do this

[dominicb]

Good afternoon Sheepkin_Coat

Assuming your values in column A start at cell A1, does this work OK for you :

=MID(A1,FIND("v ",A1)+2,FIND(",",A1)-FIND("v ",A1)-2)

HTH

DominicB

[NBVC]

I assume you mean the second team in each entry:

Try,

=MID(A1,FIND(" v ",A1)+3,FIND(",",A1)-FIND(" v ",A1)-3)

[Sheepkin_Coat]

I assume you mean the second team in each entry:

Try,

=MID(A1,FIND(" v ",A1)+3,FIND(",",A1)-FIND(" v ",A1)-3)

yes i do mean the second team, thanks

and how do i get rid of the second team and the v and the time from cell A

[NBVC]

Try:

=LEFT(A1,FIND(" v ",A1)-1)