Find and replace formula or macro

[bwaaack]

Hello, I am trying to find and replace lyMK-6Ay8fk in cell A1 with the contents of cell B2. Im looking to do this to 400 rows. Any suggestion would be appreciated. I am using excel 2015 and running windows. Thank you.
A B

1	value="http://www.youtube.com/v/lyMK-6Ay8fk?fs=1&hl=en_US"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"> <embed src="http://www.youtube.com/v/lyMK-6Ay8fk?fs=1&hl=en_US" <tbody> </tbody>	z-X42uw4c3w <colgroup><col></colgroup><tbody> </tbody>
2	value="http://www.youtube.com/v/lyMK-6Ay8fk?fs=1&hl=en_US"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"> <embed src="http://www.youtube.com/v/lyMK-6Ay8fk?fs=1&hl=en_US"	oeUzAOnZRgU <tbody> </tbody>
3	value="http://www.youtube.com/v/lyMK-6Ay8fk?fs=1&hl=en_US"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"> <embed src="http://www.youtube.com/v/lyMK-6Ay8fk?fs=1&hl=en_US" <tbody> </tbody>	ei90jH7p5YY <tbody> </tbody>
4

<tbody>
</tbody>

 

[Snakehips]

bwaaack,

Try the below in C1 and copy down...

=SUBSTITUTE(TRIM(A1),"lyMK-6Ay8fk",TRIM(B1),1)

Hope that helps.

 

[bwaaack]

Thank you so much. you saved me.