Find Partial text in an array and extract charaters to right

Hi,

Since i am newbie, please help on below query

I have "& Name: 24825" in a cell

I want to search "& Name: " in an array from colmn A to G and once found i want to extract 5 characters after that

Thanks,
Jenita