Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get rid of embedded grey squares over cells | Excel Discussion (Misc queries) | |||
how to I remove these odd squares from spreadsheet? | Excel Discussion (Misc queries) | |||
getting small cirlces and squares when i click on cells | Excel Discussion (Misc queries) | |||
only numbers in a colum are seen-no cells-no little squares | Excel Discussion (Misc queries) | |||
removing squares and lines in squares that really should be paragr | Excel Discussion (Misc queries) |