Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear empty space inside every cell in excel 2003 and 2007
Hi guys,
I have problem with empty space. In every cell before any information(value,text, no matter ) there is 1 interval. I want to remove it for entire worksheet this empty space. Is it possible? 10x in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear empty space inside every cell in excel 2003 and 2007
You can try out the below macro. If you are new to macros..
--Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From menu 'Insert' a module and paste the below code. --Get back to Workbook. --Run macro from Tools|Macro|Run <selected macro() Sub Macro1() Dim cell As Range For Each cell In ActiveSheet.UsedRange If Not cell.HasFormula Then cell = Trim(cell.Text) Next End Sub If this post helps click Yes --------------- Jacob Skaria "Don Vito" wrote: Hi guys, I have problem with empty space. In every cell before any information(value,text, no matter ) there is 1 interval. I want to remove it for entire worksheet this empty space. Is it possible? 10x in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
How do I put a "hard space" into text in a excel 2007 cell? | Excel Discussion (Misc queries) | |||
Trim Characters Other Than An Empty Space At The End Of A Cell | Excel Worksheet Functions | |||
Excel 2003: How I can use tab in a sentence inside a cell? | Excel Discussion (Misc queries) | |||
How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) |