Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using TAB as CSV delimiter | Excel Programming | |||
point as delimiter | Excel Discussion (Misc queries) | |||
delimiter | Excel Programming | |||
Text to Row by Delimiter | Excel Programming |