Greg

Option 1: Write a VBA procedure that reads in the text file and cleans out
the characters you don't want, then writes to cells. You would use VBA's
file operation keywords like Open, Input, FreeFile.

Option 2: Import the text with all the characters you want, then do a find
and replace to get rid of the stuff you don't want.

Post back if you need help with either of those options.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Greg wrote:
Can you please assist.

I have a text file that can incldue tabs, CR, and LF in the one field,
so I have delimeted the fields using a ^.

eg a field can be any combination of
^abcd....CR..abcd.TAB..abcd..CR..^

I wish to import the txt without the tabs, CR and LF. The file
contains about 24 columns, by about 200 rows.

What are my bext options?