Substitute Formula????

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
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
so why not use text to column with delimited charater ","? Then you won't need the formula
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,086
Members
412,310
Latest member
mark884
Top