Cleaning an import into Excel
Posted by David on December 12, 2001 8:26 PM
I need to import information from a contact manager that will only export into a tab delimited format. Each of the populated fields in the Excel spreadsheet now have a rectangular character following the relevant information of every cell.
I have not managed to duplicate the character, and when I cut and paste the contents of one of these cells it disappears (it does not transfer onto a clipboard)
I need an automated way to erase these rectangular characters from each one of thousands of cells. Can anyone help??