Multiple Delimiters
You should be prompted on the wizard that allows multiple delimiters. But you
only get one "other" delimeter.
When I have this kind of thing, I'll either edit the text file and change all
the other delimiters to a single common delimiter.
Or I'll bring in the text file into a single column and do the change in excel.
Then use data|text to columns to parse the data.
hassanq23 wrote:
hi ,
Is there any way i can get excel to accept multiple delimiters when
importing from a text file to an excel worksheet?
Thanks,
Hassan
--
Dave Peterson
|