I have Excel 2010 on Windows 7. I have a huge spreadsheet with 55,000 lines so I'm looking to remove all hidden tabs in each spreadsheet in one step. So the clean() function does not work for me.



I've tried the Search and Replace dialog buy holding ALT and typing 0009 to enter a tab, and replace it with blank, but that doesn't work. I get no error, and the tabs are not removed. I don't even get another dialog asking me to find the next occurrence to replace.

This spreadsheet is from a customer and no, they can't fix it, they just don't know how. And no, we can't upgrade office.

Anyone have any ideas? I can type in VBA and run some code on every cell but I'm not a VBA programmer so I wouldn't know where to start. After we remove the tabs I will export the spreadsheet to a tab-delimited file. Reprogramming the program to use this tab-delimited file would take at least a week due to my busy schedule so that is not an option here.