|
|
#10
02-26-2018, 11:56 AM
|
|||
|
|||
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
|
| Tags |
| excel 2010, tabs |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| remove tabs from cells | ewso | Excel | 5 | 12-27-2017 07:39 PM |
| Word 2010 Cross reference - remove tabs | kennethc | Word | 6 | 01-14-2015 08:54 AM |
| Excel - Color Worksheet Tabs | avie layne | Excel | 4 | 11-12-2012 04:45 PM |
| New/Custom Tabs in Excel 2010 | judicial85 | Excel | 1 | 09-27-2011 07:59 AM |
| How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode