1. Make use of Ctrl-C and Ctrl-V for Copy-and-Paste operations in
SEARCH AND REPLACE dialogue box.

2. Formula too Long ; Are you getting long text strings in single
cells ? Share each long text strings in 2 separate cells. It's quite
simply philosophical that when a job is shared, it gets lighter and
Quite Easily Done (QED). After that, Concatenate the text strings
again.

Remember?! : Analyse, Break-Down, Solve the Components and there,
Integrate into A Wholesome Solution.

Regards.