excel replacement macro question

Here is the psuedal code.

For column D
If D1 contains "Merch Theft", Replace D1 with "MT"
If D2 contains "Merch Theft", Replace D2 with "MT"
...
...

For instance, if D1 says "Merch Theft, Fraud, bla", I want it to be replaced by "MT".

I can fill up another cell by letting it equal to
=IF(ISERROR(FIND("Merch Theft", D2)), "", "MT"), but I cannot figure out a way to replace the original cells with "MT".

Thanks in advance.

1) Enter your formula in an empty column
2) Highlight the whole column of new answers
3) Ctrl-C to copy
4) Click on the first cell at the top of the original column of data (D1?)
5) Click on Edit > PasteSpecial > Values
6) Delete the helper column as it is no longer needed.


As this is a one-off, no VBA is really necessary.

A macro is another way to make this change.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Originally Posted by lecxe

Select column D, press Ctrl-H (or Edit->Replace) and use:

Find what: *Merch Theft*

Replace with: MT

Originally Posted by Tian

This will only replace "Merch Theft" part of the string into MT, i want the entire cell to be replaced with MT

I'm thinking you read it and didn't try it.