Hi,
I want to write a code to find a multiple partial values in a string and place 1 or 0 in the beside cell.
ex. a1 = "ABCDEFG"
a2 = "HGIJKLM"
a3 = "ABCDEFG"
i want to search for "CDE" or "EFG"
and place 1 or 0 in the beside cell.
the result should be
b1 1
b2 0
b3 1
i want it programatically so that i can automate. Please tell the instructions also of how to do it from beginning to end from making the code and puuting it and running it, as i am new to excel.
thanks in advance.
I want to write a code to find a multiple partial values in a string and place 1 or 0 in the beside cell.
ex. a1 = "ABCDEFG"
a2 = "HGIJKLM"
a3 = "ABCDEFG"
i want to search for "CDE" or "EFG"
and place 1 or 0 in the beside cell.
the result should be
b1 1
b2 0
b3 1
i want it programatically so that i can automate. Please tell the instructions also of how to do it from beginning to end from making the code and puuting it and running it, as i am new to excel.
thanks in advance.