View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim McC Jim McC is offline
external usenet poster
 
Posts: 5
Default 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...