Moving Part of Text into New Columns

[allanTeh]

For Example, I stored data in Column A as follows:

in A1 - Arizona v San Francisco
in A2 - Tampa Bay v Atlanta
etc...

1) What formula/function I can use to move FIRST PART of data in Column A (data BEFORE space, v, space) to Column B ?

2) What formula/function I can use to move SECOND PART of data in Column A (data AFTER space, v, space) to Column C ?


Please HELP !!!

 

[agihcam]

Duplicate;

http://www.mrexcel.com/board2/viewtopic.php?p=1108264&highlight=#1108264

 

[allanTeh]

Thank You!

Hi Mr Agihcam,

Thank You for the url you supplied, I found the posting and the answer worked for me.

Once again, Thank You!

allanTeh
Singapore