Regarding Excel Formula

[pratiksuhasaria]

Hi
Sentences
1 It is Apple
2 It is Orange

A Column Contains this two sentence in random manner. I need a formula to extract word apple or orange from the given sentences.

 

[Rick Rothstein]

If the text before the words you want is always "It is ", then...

=MID(A1,7,99)

If the text is not always "It is ", then you need to tell us more about how to identify the text you want to retrieve.

 

[pratiksuhasaria]

yes the text can be different lets say
1) I have approved your work
2) I need some clarification on your work

The words approved and clarification need to be extracted from following statements