(SOLVED) If first word = This array, then remove them and keep the rest

Hello,

Hoping this is not a tricky task. I just want a function to remove the first word of each cell if the word is part of an array such as "fox" "horse" and "Cow."

ie: Fox jumped over the cow
Output: jumped over the cow

Thank you!

Try this.. Define words in for example H column.

For a non-VBA solution..

If your sentences are in column A, then in B1 use the following formula and fill down:

=IF(OR(LEFT(LOWER(A1),FIND(" ",A1)-1)={"fox","horse","cow"}),MID(A1,FIND(" ",A1)+1,LEN(A1)),A1)

Copy the results from column B over the original values in column A (Copy, then PasteSpecial > Values).

Please Login or Register  to view this content.