Enter sign replace in Excel 2007:
How can I replace enter sign in the middle of a string for 100 000 lines
with any other sign, where the quantity of signs in cells is is different
from right for every cell.

P.s.: code formula doesn't work for it.
Any solution is acceptable macro and formulas tips.
--
Iri.