Forum Discussion
Rewriting a sentence in a cell
Hi everyone I have a data and lots of senteces are written in cells like below: HERMES AGENCIES S.A. 18th, 28th Octovriou Str. P.O.Box 1132 GR-57009 KALOHORI GREECE TEL:2310778825 FAX:2310778...
Anıl Adaş not sure why you need to do this but you can create another column and use this formula:
=SUBSTITUTE(A2,CHAR(10)," ")
here is an example of how it worked:
notice how A2 has the line returns but in B2 it is just normal word wrap.
