Get rid of tabs

G

Guest

Hello,
I have tables (originating outside MS Office) that have funny formatting.
I've been removing the undesirable formatting by saving as tab delimited
text, then resaving as xls. All has been well until I found a column of
data that contains tabs within a single cell. Then I thought of saving as a
comma delimited txt file, but commas can also be found within a single cell.

Is there a way to remove such tabs? In Excel they look like little squares.

Thanks in advance for your help,
Ellen
 

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

Get rid of small squares in column 4
How to get rid of embedded grey squares over cells 2
Problems when saving worksheet into tab-delimited text file 3
How to get range names to Apply across multiple tabs 1
best approach for a template spreadsheet to be used by others 1
How to tell number of spaces between values in saved text file fromthe original xls file 1
Automated multiple text files into multiple sheets in one workbook 14
Large Excel 2008 .xlsx file behaviour with Vista 3

Top