Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro help | Excel Discussion (Misc queries) | |||
macro interruption: help!!! | Excel Discussion (Misc queries) |