Firefox is my browser, I highlight your thread title, right click, select... Search Google for "remove tabs fro..."
The first item returned is
http://smallbusiness.chron.com/remov...eet-41719.html
The second item returned is
about the CLEAN function which you indicate having already tried. It says that ascii code values 0 through 31 are removed which should have worked for you as tab is ascii 9 .
Are you sure it's tab characters that need dealt with ?
Running this macro will
display in the Immediate Window, character by character, the ascii codes that Excel sees in the active cell.
Code:
Sub CheckOfCharacters()
Dim i As Integer, str As String
str = ActiveCell.Value
For i = 1 To Len(str)
Debug.Print Mid(str, i, 1) & " = " & Asc(Mid(str, i, 1))
Next
End Sub