Posted to microsoft.public.excel.newusers

Doug Mc

external usenet poster

Posts: 42

Multiple Delimiters

I'm trying to import a text file into a blank xls file.
It has delimters of bars (I guess - looks like an l with nothing at the top
or bottom.)
It works fine if there's only one delimiter but if there are two or more
together I can't get the columns specified.

How do I do that?

Thanks,
Doug

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Delimiters	hassanq23	Excel Discussion (Misc queries)	5	April 7th 09 01:16 AM
Use of multiple-character delimiters under Text To Columns	wildetudor	Excel Discussion (Misc queries)	3	March 16th 09 09:41 PM
Multiple "other" delimiters? Easy multiple cell merge?	pullinghairout	Excel Discussion (Misc queries)	2	November 7th 07 05:46 AM
using multiple delimiters at the same time	[email protected]	Excel Discussion (Misc queries)	2	August 2nd 06 01:45 AM
delimiting w/multiple delimiters?	NTaylor	Excel Discussion (Misc queries)	0	January 11th 06 04:22 PM

All times are GMT +1. The time now is 08:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us