Hi,

I need a function that compare text in two cells for a specific text
and if exists make edit the second cell as the first one.

For example my function willl:

1. Look for the text "#" in cell A1.
2. If "#" exists in A1 and there is a letter after it, like "#E", it
will compare it to B1.
3. If the letter after"#" is the same in A1 with B1, it should not do
anything. If the letter after "#" is different in B1 comparing to, it
needs to flag that cell by stating True or False.

Thanks in advance,
Mehmet