search and replace WHOLE WORDS ONLY
===

i'm looking for a way to search and replace WHOLE WORDS ONLY. since the whole words in my case can be separated not only by a space but .,;:/? etc. i can't think of an efficient way to code this.

basically, i'm looking to do something like this

    replace([address], ***--list of separators, like .,;:/?--*** & [replacewhat] & ***--list of separators, like .,;:/?--*** ," " & [replacewith] & " ")

i don't know how to pass a list of separators at once instead running a replace function once for each COMBINATION of separators (which combined with 300 words i'm replacing would amount to an insane number of queries)

thank you


