Thread: Delimiter(?)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
 
Posts: 80
Default Delimiter(?)

How can I separate data preceded by '<<' (without the quotes) into different columns?

Here's sample of my text file:

<< NOT a relative << Anyone get a Letter from Robert? << A
<<E-mail addresses <<What's up? << Visit <<
<< <<Sorry <<Photos from the front << New Address for Robert
<< FW: (no subject) << FW: <<FW: (no subject) <<FW:
<<Matt <<Matt <<Jeremy 's Interview << Video of 's i
<< Clemency Letter for S/Sgt Matthew << Clemency Letter
<< Matthew <<Jess's letter << Matthew << M
<<Fwd: <<Fwd: Fw: Beth Rubin & Jersey Tomatoes on TV <<The other a
<< Sorry << <<Sorry <<Photos from the front << New Addre
<<From Merrilea <<Fwd: Picture of the year <<FW: Karen G's newest G
<< and he's off << and he's off <<and he's off <<More Info
<< << << <<FW: << <<Untitled <<From Merrilea
<< Matthew << Matthew << Matthew <<
<<Google Alert - matthew- -minnesota -rugby <<Itinerary - MATT
<< Mars..Historical event coming <<Fwd: Mars..Historical event com
<<In cognito << local Cotterill mini-reunion <<Whiskey Locker is
<< << New Address for Robert << New Address for Robert