On Jun 11, 6:37 pm, "Vasant Nanavati" <vasantn AT aol DOT com wrote:
Put the following formula in C1:

=MID(A1,FIND("#",A1)+1,1)=MID(B1,FIND("#",B1)+1,1)

Adjust to suit.

Formulas cannot changecells,;ifthe formula shows FALSE you will have to
change thecellmanually or write a macro to accomplish this.

__________________________________________________ ________________________

"CyranoDeBergarac" wrote in message

ups.com...



Hi,

Ineedafunctionthatcomparetextintwocellsfor aspecifictext
andifexistsmakeeditthesecondcellas thefirstone.

For example myfunctionwilll:

1. Look for thetext"#" incellA1.
2.If"#"existsin A1 and there is a letter after it, like "#E", it
willcompareit to B1.
3.Ifthe letter after"#" is the same in A1 with B1, it should not do
anything.Ifthe letter after "#" is different in B1 comparing to, it
needs to flag thatcellby stating True or False.

Thanks in advance,
Mehmet- Hide quotedtext-

- Show quotedtext-

Thanks Vasant, that helps.