Find Text in column, cut and paste value of row below? See example

[CONFUSED1]

Ron,


Just to clarify, the code I was pasting in was overwriting everything after my first three lines, I was not putting it at the end.


I appreciate the advice and reasoning behind not combining the replace functions and the advantage for doing them separately.