Substitute Formula????

[excel_training_wheels]

Hi--

I am getting close with the formula I am using, but need help modifying it. I have the following all in one column, column A.

Athens,GA,USA
Paris, France
Cancun,MX
Rome,Italy
London,United Kingdom

I am using =SUBSTITUTE(RIGHT(A2,SEARCH(",",A2)),"(","") but it isn't giving me exactly what I need. I want to separate into columns. For example, I want Athens in one column, GA in one column, and USA in another column.

Same with the others. I want Paris in one column, and France in another.

HELP

 

[Andrew Poulsom]

Data|Text to Columns, with comma as the delimiter, is the easiest way to go.

 

[texasalynn]

so why not use text to column with delimited charater ","? Then you won't need the formula

 

[excel_training_wheels]

Thanks, I assumed this was going to be super complicated, and I guess not!