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