View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MKB MKB is offline
external usenet poster
 
Posts: 1
Default testing for character strings within a cell

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.