Delete ALL text to the left of a particular character in MS excel

Question

This is an excel related question. I want to delete all text (all characters) to the left of a particular character or characters in the string.

For instance:

suppose I have an string in a cell helloall welco metostackoverflow

now I want delete all the characters which are at the left side of "stack". means result should be stackoverflow (only stackoverflow)

Thanks in advance for your support.

Answer 1

=RIGHT(input,LEN(input)-FIND("stack",input)+1)