Extract text between symbols version 2

[Jim McC]

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]

With nothing in columns B to whatever...

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