Using text to columns to separate something like Everton v Coventry

[Interesting Ian]

I'm using the "text to columns" function to separate a column of football
teams in the form Manchester United v Chelsea etc so that the first team is
in one column and the second team in another. I used the delimited file
type and put in a "v" in the other checkbox. However that made a mess of
the teams which have a v in them like Everton and Coventry! Is there any
way I can get around this?

Thanks

 

[Dave Peterson]

I'd try this:

Select the column
Edit|Replace
what: _v_ (space character, v, space character)
with: | (vertical bar--or comma or some unique unused character)
replace all

Then use data|text to columns and use delimited by | (or that unique character)

 

[Interesting Ian]

Hi, thanks. Yes I think that should work.

I'd try this:

Select the column
Edit|Replace
what: _v_ (space character, v, space character)
with: | (vertical bar--or comma or some unique unused character)
replace all

Then use data|text to columns and use delimited by | (or that unique
character)

 

[Pete_UK]

And it will get rid of the spurious spaces (ref your previous posts).

Pete