Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching for a type of string
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching csv files for particular string | Excel Programming | |||
searching through a string? | Excel Programming | |||
changing the default type of searching in the find function | Excel Discussion (Misc queries) | |||
Searching a String | Excel Programming | |||
searching a string with a partial string | Excel Programming |