PDA

View Full Version : Solved: Split 1 Cell into 2 cells



Emoncada
08-28-2008, 10:29 AM
I have a column of NFL Games.
I want to seperate them.
Example

Column B
NY Giants at Washington Redskins

I would like it to be
Column B..............Column C
NY Giants.............Washington Redskins

How can I do this? Maybe finding the word "at" then Breaking it up?

Bob Phillips
08-28-2008, 10:53 AM
B1: =LEFT(A1,FIND(" at",A1)-1)
C1: =MID(A1,FIND(" at ",A1)+4,99)

Emoncada
08-28-2008, 11:08 AM
XLD you once again helped me out. Works Perfectly.
Thanks.