testing for character strings within a cell
=IF(ISNUMBER(FIND("shell",A1)), "found","not found")
"MKB" wrote:
Is there an easy way to test the contents of a cell for a particular
character string? I have a number of records that I've dumped out of an
AS400 application and need to search one column for the word "Shell". The
word is only part of the cell contents and is a varying number of spaces from
the beginning or end of each respective character string.
|