importing txt file!

[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

 

[macropod]

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