Could anyone advise how I could remove unwanted characters from a string.
In particular, I have imported telephone names and numbers into EXCEL, but would like to retain or extract only all text or numeric characaters without other symbols, i.e. clean the text up.
as an example:
John & Sons * (pty. ltd)
tel: 02/365,37890
remove from above any symbols or ALL non ASCII characaters as given below:
&, (./, ?^$£à§é!|"%/
- or any non text or numeric charcater
as I do not have much familiarity with programming something done if possible in Access and simple would be appreciated.
thanking you in advance
In particular, I have imported telephone names and numbers into EXCEL, but would like to retain or extract only all text or numeric characaters without other symbols, i.e. clean the text up.
as an example:
John & Sons * (pty. ltd)
tel: 02/365,37890
remove from above any symbols or ALL non ASCII characaters as given below:
&, (./, ?^$£à§é!|"%/
- or any non text or numeric charcater
as I do not have much familiarity with programming something done if possible in Access and simple would be appreciated.
thanking you in advance
