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!