Help with Function: Compare text and and edit in cells
 

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

Help with Function: Compare text and and edit in cells
 

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" wrote in message
ups.com...
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

Help with Function: Compare text and and edit in cells
 

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.