Avatar of Richard Kreidl
Richard Kreidl
Flag for United States of America

asked on 

Search for string in Excel column with many rows.

I have an Excel spreadsheet with over 23500+ rows that I would like to search column "B" for certain strings.

If one of the strings are found that I'm looking for,  then the word "present' would be put in the next column "C" in the same row.

These are the strings I need to look for.
They can either be lower or higher case letters:
re-start
restart
hold
ice
kill
terminate
inactive
success
force
start


Thanks
test.xlsx
VBAMicrosoft Excel

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon