User Profile

YasserKhalil · May 6 '15, 07:02 PM

Ok Mr. Rabbit
Sorry I'm newbie here
Here's a code I tried to modify but I failed

Code:

Sub RemoveSpacesBeforeAfterSlash()
    Dim A, I As Long, M As Object
    With Cells(1).CurrentRegion.Resize(, 1)
        A = .Value
        With CreateObject("VBScript.RegExp")
            .Global = True
            .Pattern = "*( / *)?"
            For I = 1 To UBound(A, 1)

...

YasserKhalil · May 6 '15, 06:01 PM

Thanks Mr. Rabbit for reply
Can you provide me the code or the UDF function that enables me do that task?

YasserKhalil · May 5 '15, 04:31 PM

Thank you very much Mr. Luuk for this simple and efficient solution

YasserKhalil · May 5 '15, 01:30 PM

Thanks for your reply Mr. Luuk
It seems now that I have to stop thinking about that point
Thank you very much

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Remove any number of spaces before and after slash

Leave a comment:

Use Enter key to navigate in special way

Leave a comment:

Diasble Ctrl + Alt + Delete