excel_training_wheels
Board Regular
- Joined
- Aug 25, 2005
- Messages
- 193
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
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