1. Assuming you mean Tab chars in-cell.

Sub Remove_Tabs()
With Selection
.Replace what:=Chr(9), replacement:=Chr(32), _
lookat:=xlPart, SearchOrder:=xlByRows,
MatchCase:=False
End With
End Sub

2. Would depend upon the layout of the sheets.


Gord Dibben Microsoft Excel MVP



On Tue, 16 Aug 2011 17:29:13 +0300, "Alonso"
wrote:

1. after conversion pdf document to xls file, there is a small square
symbol(tab) in many cells inside this excel file: how to remove it all at
once? (with some option or via macro). Excel 2003.


2. how to join a few excel sheet (inside one excel file) into one sheet?
(table with data was splitted into few worksheets)

thank you!