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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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