Removing Carrage returns squares

D

Dkdom

Hi,

I have table to import from excel which contains text which has carrage
returns in it when the text is imorted it contains square characters, i have
seen other posting relating to how to remove them, but is there anyway to
avoid them appearing in the first place?

I am importing the file as a *.txt as the when i try to import as *.xls as
get the error i get the error "subscript out of range" any help on this would
be good too.

Kind Regard

Dkdom
 

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

Top