Arrghhhhhhhhh I've been trying to do this for weeks!
We have a report which arrives with 30,000 lines of different part numbers.
And we need to extract just the alpha(A-Z or a-z) numeric (0-9) characters from it, leaving out all of the dahses, slashes, underscores, spaces and everything else that people manage to include.
For example
AS-B___8/4%9-016d needs to be ASB849016D
Ab'D-A/9(00)-7[5-M-T8"16 needs to be ABDA90075MT816
The only solutions I can find involve macros, script & UDF's....and that's just about smashed my learning to pieces!!!
Would anybody have a version which could help us to get this done using those?
PS Wonderful site gents, many many thanks!
We have a report which arrives with 30,000 lines of different part numbers.
And we need to extract just the alpha(A-Z or a-z) numeric (0-9) characters from it, leaving out all of the dahses, slashes, underscores, spaces and everything else that people manage to include.
For example
AS-B___8/4%9-016d needs to be ASB849016D
Ab'D-A/9(00)-7[5-M-T8"16 needs to be ABDA90075MT816
The only solutions I can find involve macros, script & UDF's....and that's just about smashed my learning to pieces!!!

Would anybody have a version which could help us to get this done using those?
PS Wonderful site gents, many many thanks!