importing txt file!

  • Thread starter Thread starter via135
  • Start date Start date
V

via135

hi all!

i am having a text file delimitted with a non printable character
(like a small squre)..! while importing it into excel what should i
give in the delimiter option..?

any help pl..!

regds!


-via135
 
Hi via135,

Unles you can edit the text file, you'll need to find out what character it is.

It might be easier, though, to open the file in Word, for example, copy the character, then do a find/replace, pasting the copied
character into the Find box, and changing it to something else.

Cheers
 
Back
Top