I want to input the below formula's into a couple of ranges

Column A1 contains various information that include a "&" in the range
Range B1 through C10 I want to input

=find("&", A1) GOES INTO B1
=mid(A1, B1+1, 5) GOES INTO C1

Then this is copied down until row 10

I can't seem to get it right.