I don't know how to do it using Find and Replace but the leading pilcrow can be removed whilst still pushing the text down as per column 1 if that is the effect you are after. See photo.
Column 1 has the leading pilcrow before Name1 but column 2 has no leading pilcrow.
|