Here is another way...

=ISNUMBER(FIND("x"&RIGHT(A1,2)&"x","x0Mx1Mx2Mx3Mx4 Mx5Mx6Mx7Mx8Mx9Mx"))

It's longer, but it uses less function calls.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Give this a try...

=ISNUMBER(--MID(A1,LEN(A1)-1,1))*EXACT(RIGHT(A1),"M")

--
Rick (MVP - Excel)


"Roger on Excel" wrote in message
...
I use the following to search for "M" at the end of a word :

=IF(EXACT(RIGHT(A1,1),"M"),1,0)

it returns 1 for true and 0 for false.

This is fine, but I need to expand the expression so that it returns 1
only
if the end of the string is a number followed by M.

For example :

xxxM = 0
3.2M =1
xxxm = 0
xxx m = 0
5M = 1
6.0M = 1

Can anyone help?

Thanks, Roger