Macro to remove squares from cells
 

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!

Macro to remove squares from cells
 

On Aug 16, 9:29*am, "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!
try

SUB noshapes()
for each sh in activesheet.shapes
sh.cut
next
end sub

Macro to remove squares from cells
 

On Aug 16, 9:29*am, "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!

OR
select cells(square in upper left)f5specialshapescut

Macro to remove squares from cells
 

"Don Guillett" wrote in message
...
On Aug 16, 9:29 am, "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!
try

SUB noshapes()
for each sh in activesheet.shapes
sh.cut
next
end sub
--------

not help. Also, other way also not help - there are no schapes found when
select cells(square in upper left)f5specialshapescut

Macro to remove squares from cells
 

Don Guillett brought next idea :
On Aug 16, 9:29*am, "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!

OR
select cells(square in upper left)f5specialshapescut

Don,
I believe what's happening is the paste of the PDF contents is
including 'printable' characters for CR, LF, Tab. These will be text,
no?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Macro to remove squares from cells
 

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!

Macro to remove squares from cells
 

"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.

Macro to remove squares from cells
 

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.