importing txt file!

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
 
M

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
 
Top