Split text to compare
 

Dear all

I have a code extracted A1 from the system and looks like. Bill.Eko1
Bill.Eko37
Bill.Eko123

There is any possible way to keep from the code the right part of the code,
anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text in
next cell B1

To compare them in C1.

Thanks in advance
Manos

Split text to compare
 

Something like this maybe...

=MID(A1,FIND(".",A1)+1,99)=B1

Rick


"Manos" wrote in message
...
Dear all

I have a code extracted A1 from the system and looks like. Bill.Eko1
Bill.Eko37
Bill.Eko123

There is any possible way to keep from the code the right part of the
code,
anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text
in
next cell B1

To compare them in C1.

Thanks in advance
Manos

Split text to compare
 

Here is another way to do it also...

=COUNTIF(A1,"*."&B1)=1

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Something like this maybe...

=MID(A1,FIND(".",A1)+1,99)=B1

Rick


"Manos" wrote in message
...
Dear all

I have a code extracted A1 from the system and looks like. Bill.Eko1
Bill.Eko37
Bill.Eko123

There is any possible way to keep from the code the right part of the
code,
anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text
in
next cell B1

To compare them in C1.

Thanks in advance
Manos

Split text to compare
 

Thanks

"Rick Rothstein (MVP - VB)" wrote:

Something like this maybe...

=MID(A1,FIND(".",A1)+1,99)=B1

Rick


"Manos" wrote in message
...
Dear all

I have a code extracted A1 from the system and looks like. Bill.Eko1
Bill.Eko37
Bill.Eko123

There is any possible way to keep from the code the right part of the
code,
anything after to dot (Eko1, Eko37, Eko 123.) and compare it with a text
in
next cell B1

To compare them in C1.

Thanks in advance
Manos