I don't think you can even enter tabs into an Excel cell. If you have, how did you manage it, because I have so far been unsuccessful. So maybe where you think there are tabs there actually aren't any.
For example copy some text from Word that has tabs in it. When this is pasted into Excel, the tabs get replaced with spaces.