Rewriting a sentence in a cell

Question

Hi everyoneI have a data and lots of senteces are written in cells like below:HERMES AGENCIES S.A.18th, 28th Octovriou Str.P.O.Box 1132GR-57009 KALOHORIGREECETEL:2310778825FAX:2310778875And I need to rewrite the sentece like below for each cell:HERMES AGENCIES S.A. 18th, 28th Octovriou Str. P.O.Box 1132 GR-57009 KALOHORI GREECE TEL:2310778825 FAX:2310778875&nbsp;Please help me if you know any&nbsp;possibility to do that stuff. Also added an example file to make you understand better the data I have.&nbsp;&nbsp;

mtarler · Answer

Anıl Adaş&nbsp; not sure why you need to do this but you can create another column and use this formula:=SUBSTITUTE(A2,CHAR(10)," ")&nbsp;here is an example of how it worked:notice how A2 has the line returns but in B2 it is just normal word wrap.&nbsp;

anıl adaş · Answer

mtarlerThanks a lot for your replyI used CLEAN function and solved my problem but also tried yours[=SUBSTITUTE(A2,CHAR(10)," ")] and it was very helpful for one of my projects

Forum Discussion

Rewriting a sentence in a cell

2 Replies

Resources