Question about text formula?

[gstevens]

I have a column of rows that includes text vs. text; I need to extract the text to the right of the “vs.” for every row in the list in a new column. I have no problem if the text is fixed but it is various lengths of characters and not static. Any help is much appreciated.

Examples:
Yesterday vs. today. I need the word “today” in a new column but same row.

Red vs. yellow. I need the word “yellow” in a new column but same row.
Etc.

Thanks.

 

[Jonmo1]

Welcome to the board...

Perhaps
=MID(A1,FIND("vs.",A1)+4,LEN(A1))


Hope that helps.

 

[Trevor G]

Welcome to the board,

Place this in the next column and then fill down

=MID(A1,FIND("vs.",A1)+4,LEN(A1))

 

[gstevens]

Wow –Perfect; first try. Thanks much!