Find a string by VBA Regular Expression and replace a part of that string

Hi All,

I would like to find ; (semicolon) which does not contain double quote on both side of it in an excel range (say- A1 to A10).
Then all [any character] ; [any character] should replace with [that character] - [that character].

Examples:

a;b ---> a-b
a; b ---> a- b
a ;b ---> a -b
a12c;d25dd ---> a12c-d25dd
a123;425dd ---> a123-425dd
a123";"325dd ---> a123";"325dd (No change)
a123;"325dd ---> a123;"325dd (No change)
a123";325dd ---> a123";325dd (No change)

Thanks in advance for your support.

Regards
taps

Why to use just RegEx? another method can't be used?

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

Hi hafizimran/JosephP/jindon

Thanks a ton for your valuable support. All codes provided here is working fine

Regards
taps