if not numeric and letter then replace character help

[DKY]

I have a list of supplier part numbers and our system will not handle special characters so I'm trying to write a visual basic function that pretty much says if there are any characters in a cell that are not numberic and not letters then remove them. I know that there's a isnumberic function but can't for the life of me figure out how to use it and a letter counterpart to achieve this purpose.

So far, I'm replacing things as I come accross them but I'm thinking that it's not really a good idea to have to edit the code every time I come accross something new.

Please Login or Register  to view this content.

[Richard Schollar]

Hi
You can use a Regular Expression for this eg:

Please Login or Register  to view this content.

[DKY]

I'm trying to keep the prefix too so I changed the code to look like this but it doesn't work with the prefix part, how can I adjust it?

Please Login or Register  to view this content.

[DKY]

Nevermind, I found the error

Please Login or Register  to view this content.

This is perfect, thank you!