Help! edit multi-cells with conditions. Thank all of you!

[imbaboy95]

Hi, i am student, i need Macro to edit about 3000 quizzies like that ( i edited about ~ 200 quizzes). You can see below, every question contain { content } . I need { } is first variable to define as range to replace content in { } and Answer (A) or Answer (B/D/D) are 2nd variable to define.

Exp: 4PoE5cI.png

1. We defined Question 1 have { } and next we find in {} contain Answer (B) now Macro will replace (B) One year to
/=(B) One year. Replace Other choice (A/C/D) to ~(A) Many years ~(C) Until next month ~(D) Today

Question 1. For how long can this product be enjoyed?
{
(A) Many years
(B) One year
(C) Until next month
(D) Today
####
Answer (B)
More: asd qwe eiquwei oquwoe uqiw ueqio quweo iqwuoe
}

----------After running Macro-->
Question 1. For how long can this product be enjoyed?
{
~(A) Many years
/=(B) One year
~(C) Until next month
~(D) Today
####
Answer (B)
More: asd qwe eiquwei oquwoe uqiw ueqio quweo iqwuoe
}

-------------------------------------------------------------------------------
2. We defined Question 2 have { } and next we find in {} contain Answer (C) now Macro will replace (C) Four to /=(C) Four

Question 2. How many different sizes does the product come in?
{
(A) A variety
(B) Two
(C) Four
(D) One for each customer
####
Answer (C)
More: 123 13 1 4 1j4 k1jl4kj 1kl3 1k23jl1
}

------------After running Macro-->
Question 2. How many different sizes does the product come in?
{
~(A) A variety
~(B) Two
/=(C) Four
~(D) One for each customer
####
Answer (C)
More: 123 13 1 4 1j4 k1jl4kj 1kl3 1k23jl1
}
------------------------------------------------------------------
Other Forums:
https://www.mrexcel.com/forum/excel-...k-all-you.html
https://stackoverflow.com/questions/...ank-all-of-you
https://www.excelforum.com/excel-pro...ll-of-you.html
https://www.excelguru.ca/forums/show...ank-all-of-you!
http://www.vbaexpress.com/forum/show...ank-all-of-you!


Thank all of you!