macro to eliminate spaces between words
i've a book full of references made wrong , for example the correct refernce
is FFF and in my book i've F F F. It's possible with a macro eliminate this spaces? Help me please. My book has 10 pages all wrong:( Thanks |
Hi
why not use 'Edit - Replace' for this? -- Regards Frank Kabel Frankfurt, Germany "CSAM" schrieb im Newsbeitrag ... i've a book full of references made wrong , for example the correct refernce is FFF and in my book i've F F F. It's possible with a macro eliminate this spaces? Help me please. My book has 10 pages all wrong:( Thanks |
Csam
Public Sub Strip_WhiteSpace() Selection.Replace What:=" ", _ Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False End Sub Note: will remove ALL whitespace before, between and after. Gord Dibben Excel MVP On Thu, 16 Dec 2004 08:57:01 -0800, "CSAM" wrote: i've a book full of references made wrong , for example the correct refernce is FFF and in my book i've F F F. It's possible with a macro eliminate this spaces? Help me please. My book has 10 pages all wrong:( Thanks |
Thanks. I'll try this way.
"Gord Dibben" wrote: Csam Public Sub Strip_WhiteSpace() Selection.Replace What:=" ", _ Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False End Sub Note: will remove ALL whitespace before, between and after. Gord Dibben Excel MVP On Thu, 16 Dec 2004 08:57:01 -0800, "CSAM" wrote: i've a book full of references made wrong , for example the correct refernce is FFF and in my book i've F F F. It's possible with a macro eliminate this spaces? Help me please. My book has 10 pages all wrong:( Thanks |
All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com