1. compile error because of line-wrap. Try again with this.

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

2. Depends upon the layout of the sheets.


Gord


On Wed, 17 Aug 2011 14:03:28 +0300, "Alonso"
wrote:


"Gord" wrote in message
.. .
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!
-----------

1. not work, compile error.
here is pic what I mean:
http://img843.imageshack.us/img843/6837/shapesr.jpg

how to remove squares with default excel options(preferable), or formula, or
macro(simple)?

2.What is simple formula (not macro) to merge four excel worksheets into one
work sheet(continious data) with one click?

Thank you.