Formula to Find and Display Characters that Follow

[meppwc]

Can someone assist with a formula that I need?
Example
In cell H2 I have multiple lines of information
The cell may or may not contain the following in capital letters: CAD
If "CAD" exists somewhere in the cell, then I want to display the 10 characters that follow
If "CAD" does not exist in the cell then the cell is left blank
This formula will exist in cell S2
Once I have the formula I will copy it all the way down to S100

 

[Fluff]

How about

=IFERROR(MID(H2,FIND("CAD",H2)+3,10),"")

 

[meppwc]

Works perfectly, thanks so much

 

[Fluff]

You're welcome & thanks for the feedback.