Macro to remove multiple characters in column?

Hello,

I have lots of words in column in this format:

adidas (running) shoes - size 32/34\37

I want to remove these characters ( ) - , and replace these characters / \ with space.

Is it hard to make macro to do this? I can do this manually but i am working with lot of text like this and with macro it will be faster.


Thanks!

Hi,

There's another easy way to do that, use find and replace. Here's how:
1. Select the entire column
2. Press Ctrl+H
3. Then fill-up the data required and press Replace All

And If You really want macro You can use such code

Please Login or Register  to view this content.