Boo me..

In B2:
=LEFT(A2,FIND(",",A2)-1)
in C2:
=MID(A2,FIND(",",A2)+2,2)
in D2:
=RIGHT(A2,LEN(A2)-FIND(" ",A2,FIND(",",A2)+2))

"Pete_UK" wrote:

That would put OAK in one column and PARK in another.

Pete

On Oct 2, 5:04 pm, Sean Timmons
wrote:
Highlight your column, go to:

Data - Text to Columns - Delimited - (space). You can also set , as your
delimiter and treat consecutive delimiters as one to get rid of the comma..