Find word and insert formula in cell to right

**ScabbyDog** · 04-09-2013, 12:07 PM

I want to find "Running Time" in column A. The words can appear within other words in a cell in column A, so cell Ai for example could be "The Running Time 123456789". I want the macro to recognize that it has found this term in this cell in column A and then in column B row i insert a formula to return the 9 characters to the right of the word Running Time, so cell Bi would be 123456789. I then want the macro to copy this cell.

Thanks in advance.

**AndyLitch** · 04-09-2013, 12:15 PM

=IF(ISERROR(FIND("The Running Time",A1)),"",RIGHT(A1,9))

**ScabbyDog** · 04-09-2013, 03:58 PM

Thanks for the formula Andy, that works when I know where the words The Running Time will be. The issue however is that I need a macro to find those words first as they could be in any row in column A. Can you or anyone else write a macro for that part of my problem? Thanks again.