Help to create a macro - Find special characters and replace

So im trying to create a macro that finds all characters that are not letters, numbers or dashes - and replacing them with a space. i'm trying and failing

so if in a cell it had. - > Jim(04)"$42" it would replace everything with - >Jim 04 42 there would be a space at the end as well

So it would essentially look for any and all special characters !@#$%&^*)( including ones from older versions of excel (im assuming thats what they are from). like there are different type of quotes and different types of spaces to I've noticed in my files from other companies. that find and replace cant find.

This part i know how to do and wont need any help with:
i would also need to add in, =Lower =trim and =clean into the macro and the Searching and replacing double spaces with just 1 space (about 3 or 4 times) and then replace the spaces with dashes so it would be like jim-04-42 i can do that part but if anyone knows how to create

IF ANYONE CAN HELP ME OUT I WILL VERY THANKFUL!

Another possibility maybe.
Put all the to be deleted characters in an array like in this example.

Please Login or Register  to view this content.