Extract text between symbols version 2
 

A B C
D E F
1 RDU/ATL/MXP_FCO/ATL/RDU RDU ATL MXP_FCO ATL RDU
2 ZRH/JFK/RDU ZRH JFK RDU


I am looking for a formula that will extract text between the "/" in column
"A" to get the output in columns "B" through "F". I would assume that to ge
the output in column B I would want something that said pick up the
characters until I get to the first "/". To get the output in column C, I
would need something that said I want the text between the first "/" and the
second "/". etc...

Extract text between symbols version 2
 

With nothing in columns B to whatever...

Select column A
Data|Text to columns (xl2003 menus)
delimited
by /
and finish up the wizard.



Jim McC wrote:

A B C
D E F
1 RDU/ATL/MXP_FCO/ATL/RDU RDU ATL MXP_FCO ATL RDU
2 ZRH/JFK/RDU ZRH JFK RDU

I am looking for a formula that will extract text between the "/" in column
"A" to get the output in columns "B" through "F". I would assume that to ge
the output in column B I would want something that said pick up the
characters until I get to the first "/". To get the output in column C, I
would need something that said I want the text between the first "/" and the
second "/". etc...

--

Dave Peterson

Extract text between symbols version 2
 

Select cells containing strings in column A,
DataText to columnsSeparated, check other and enter / as separator, Finish

Regards,
Stefi

€žJim McC€� ezt Ã*rta:

A B C
D E F
1 RDU/ATL/MXP_FCO/ATL/RDU RDU ATL MXP_FCO ATL RDU
2 ZRH/JFK/RDU ZRH JFK RDU


I am looking for a formula that will extract text between the "/" in column
"A" to get the output in columns "B" through "F". I would assume that to ge
the output in column B I would want something that said pick up the
characters until I get to the first "/". To get the output in column C, I
would need something that said I want the text between the first "/" and the
second "/". etc...