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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trailing minus 10
CSV file delimiter 1
open file with multiple types of delimiters 2
may be SP! 5
error msg! 1
txt fle opening with gzview! 1
Importing Text Files Into Access 1
Tab delimited to comma delimited 3

Back
Top