Search or find formula to return data (Excel Formula)

[Chris165]

Not sure if there is a way where you can search/Find a specific word using an excel formula, For Example the word"Week" and if Week is found in the cell, then it returns the next 6 or 7 characters?

So it would take the commentry out of cell A2 and if the word "Week" is visible, it would show week 11 in cell B2.

 

[Hui]

B2: =RIGHT(A2,LEN(A2)-FIND("Week",A2)-len("Week"))

 

[Chris165]

B2: =RIGHT(A2,LEN(A2)-FIND("Week",A2)-len("Week"))

Thank You!