Find if a formula in a row end's with specific word in string

If you want to check whether B2 ends in "NEWLINE" you could use:

=IF(RIGHT(TRIM(B2),7)="NEWLINE","OK","Not OK")

Or if "NEWLINE" will be variable (and of variable length) that is stored in C1 for example then:

=IF(RIGHT(TRIM(B2),LEN($C$1))=$C$1,"OK","Not OK")

or simply:

=IF(COUNTIF(B2,"*"&$C$1)=1,"OK","Not OK")

I'm afraid I don't know the Portuguese equivalents, but hopefully the attached file will be of use.

Thanks!

This will do it! Seem's I was only wrong by using left instead of right.

Originally Posted by nick.williams

=IF(RIGHT(TRIM(B2),7)="NEWLINE","OK","Not OK")

Yes, you also had the length of the string as 1, which I changed to 7.

Originally Posted by nick.williams

Yes, you also had the length of the string as 1, which I changed to 7.

Yes. I forgot that also...

Glad I can count with your precious help.

Thanks once again.

You're welcome, glad I could help