Find and replace characters.

I an attempting to write a script that can find things like "\"," " ", "*", and even ","..., now I need to replace them with either "-" or nothing. Is there a way to do this if so how?

But in editing, I can't remove the cell itself... it will look like this. Nexx Systems, Inc. and will become Nexx Systems Inc

Thanks.

Originally Posted by rvasquez

Okay below is a code that should work for you

Please Login or Register  to view this content.

To enter the code as a macro hold down the Alt key and press F8. In the macro name box provided delete anything in it and then type GetSymbol and select the create option.

In between the

Please Login or Register  to view this content.

and the text

Please Login or Register  to view this content.

Copy and paste the above code.

Then exit out of VBA. To run the code select Alt+F8 again and then select the GetSymbol option and select Run.

Let me know if this works for you!

Thanks!

How do I add in multiple items? I know which ones I need replaced? I just need the code to run, I really don't want an input box, I hope you understand but basically I am trying to make this work without the end user knowing it's being done for them.

I found this, but I need to only change what is in S and T, down to the last row of each...

Please Login or Register  to view this content.

The other issue is I need to make this work on a specific sheet, not the entire workbook...

What I'd like it to do is to replace the extra characters with a "-" even the ", so that it can be made into a folder. Basically I have this as a script so far:

Please Login or Register  to view this content.

But for some reason it's not replacing the " and the , as it should in theory...

Originally Posted by rvasquez

Please Login or Register  to view this content.

I think you responded before I edited the post. I'll use what you have if nothing else can be done, but I need it for two columns, not the entire sheet.