Tash Point O
New Member
- Joined
- Feb 12, 2018
- Messages
- 47
Hello!
I have recorded a macro to find an exact string and replace it to a different format. However, I have different strings and in the macro I would have to put in all the different variations in order for the macro to work. Is there another way I can change various strings to a certain format. Here is the example of what the heck I'm talking about. I need to change Column A's format to Column B's format.
[/IMG]
Here is the macro I recorded, as you can see, I'd have to put in every instance for strings from Column A:
[/IMG]
I have recorded a macro to find an exact string and replace it to a different format. However, I have different strings and in the macro I would have to put in all the different variations in order for the macro to work. Is there another way I can change various strings to a certain format. Here is the example of what the heck I'm talking about. I need to change Column A's format to Column B's format.

Here is the macro I recorded, as you can see, I'd have to put in every instance for strings from Column A:
