Help with Function: Compare text and and edit in cells

[CyranoDeBergarac]

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

 

[Vasant Nanavati]

Put the following formula in C1:

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

Adjust to suit.

Formulas cannot change cells,; if the formula shows FALSE you will have to
change the cell manually or write a macro to accomplish this.

__________________________________________________________________________

 

[CyranoDeBergarac]

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.

__________________________________________________________________________










- Show quotedtext-

Thanks Vasant, that helps.