Quote Originally Posted by rlv View Post
oops. Minor function error. I was in too much of a hurry. This line was erroneously inside the loop.

CleanContactNumber = CleanNumber
Corrected above and reposting the file here.
Wow !!!

You guys seems to be having excel equations for Food.

So many methods to tackle one issue.

Thanks a lot brother for your kind support for this helpless Guy

But I will have to go with mdmackillops method because there are instances where these symbols seem to appear on addresses and many other character fields.

NEVERTHELESS your equation and effort will not go in vain, its saved for my future reference as I am a collector A Big Thank you for all you amazing people. Bye.