How to import .xls containing sometext...&...sometext...>...sometext

0
Got an excel file that fails on importing it using the “excel importer” but that does succeed if I first remove the ‘&’ and ‘>’ from the .xls Is there any way to make the import succeed without first having to remove the odd characters?
asked
1 answers
1

Hi Tim,

What happens if you set the cell type of the cell with that content to Text instead of General?

Cheers,

Jeffrey

answered