remove tabs from cells

NoSparks · #2 12-09-2017, 05:38 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove spaces from Cells which are at the end of value?	LearnerExcel	Excel	2	12-19-2016 01:10 PM
Remove borders from cells	otuatail	Excel	1	08-12-2016 05:25 AM
Default Auto fill cells on one Tab from other Tabs	rs456a@att.com	Excel Programming	15	06-06-2015 09:48 AM
Word 2010 Cross reference - remove tabs	kennethc	Word	6	01-14-2015 08:54 AM
Unwanted tabs in table cells	deltaskye	Word	5	01-27-2012 11:58 AM