View Single Post
 
Old 02-26-2018, 11:56 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

I'd select the cells concerned and run a macro
Code:
Sub RemoveTabs()
    Dim rng As Range, cel as Range
Set rng = Selection
    For Each cel In rng
        cel.Value = Replace(cel.Value, Chr(9), "")
    Next cel
End Sub
Reply With Quote