Using text to columns to separate something like Everton v Coventry

  • Thread starter Thread starter Interesting Ian
  • Start date Start date
I

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
 
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)
 
Hi, thanks. Yes I think that should work.

Dave Peterson said:
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)
Click to expand...
 
Back
Top