Select the cells you which to modify and run this small macro:

Sub ReturnKiller()
returnn = Chr(10)
NewChar = "?"
For Each r In Selection
v = r.Value
v = Replace(v, returnn, NewChar)
r.Value = v
Next
End Sub

It will replace the embedded ENTER characters with a question mark.
--
Gary''s Student - gsnu200860


"Zasipkina" wrote:

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.