Identifying Last Word in a String (need function fix)

[Platinum3x]

I'm trying to identify if the last word in a string contains SCANNER. I have tried different code and posted a failed attempt below. Can anyone help fix this code?

Please Login or Register  to view this content.

SERVICE CHARGES
SCAN HV MAINT
LOW VOLUME SCANNER MAINT
MED LOW VOLUME SCANNER

If I have the above items, I only want to see TRUE for the MED LOW VOLUME SCANNER items, since SCANNER is the last word in the string. This will always be the case with my data. No other item ends with SCANNER and so I wan't to know when that string combination is true.

Thanks in advance!

[Jonmo1]

Try

=TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",LEN(A1))),LEN(A1)))="SCANNER"

[AZ-XL]

=IF(ISERROR(FIND("SCANNER",RIGHT(TRIM(A1),8))),FALSE,TRUE)

After trim function spacebar character is not deletiing, thus i used this function. Otherwise the function would be simpler

[tigertiger]

Perhaps

="SCANNER"=RIGHT(TRIM(A1),7)

[AZ-XL]

Ok
last character is not space bar. Its char(160)
this function will work too

=right(substitute(a1,char(160),""),7)="scanner"

[Platinum3x]

Thanks guys, I got it solved! I used AZ-XL's answer above:

Please Login or Register  to view this content.

Works like a charm! I really appreciate all the help.