searching text
Posted by Chris on October 23, 2001 6:55 AM
Which formula could I use to search a cell containing text for a particular bit of text ?
ie : search "Operational and Organisational expenses" for "organ"
Posted by Aladin Akyurek on October 23, 2001 7:00 AM
For case-sensitive search
=FIND(B1,A1) where B1 contains the bit (substring) you want to look for, A1 the target string.
Use SEARCH instead of FIND for the case-insensitive search.
These functions give the pos of the substring in the string if it's found, otherwise #N/A.
=ISNUMBER(SEARCH(B1,A1))
will give you either TRUE or FALSE.
Aladin
