Forum Discussion
Solved
How to devide text data ( adress ) devided by commar into text with text wrap
Hey community,
is there a smart way to convert address data devided by comma into a new cell with text wrap?
I have following text: Examplestreet 1, 12345 City and I would like to get it into this format:
Examplestreet 1
12345 City
Currently I am using "text in columns" and set up the "," as identifier. This is giving me the adress data into seperate cells ( cell A = street) ( cell B = City )
Once done I am putting these together with =A1&sign(10)&B1.... etc
Else I tried already =substitute (Cell; ","; Sign(10)) which should replace the comma by the text wrap but this seems not to work for some reason.
Any idea is much appreciated
thanks
=SUBSTITUTE( C6,", ", CHAR(10))With this formula the space is removed. The difference is ", " instead of ",". In the new formula there is a space after the comma.
=SUBSTITUTE( C6,",", CHAR(10))This formula works in my sheet if i activate "wrap text" in the cell with the formula.
Thank you! Now it works well, but I have the same issue as you have 😃 I have an empty space right before the zip which makes it not to be aligned in wrap text. any further idea how to solve that in a quick way? * I found a way to fix it by just adding the empty space into the formular: ", " *
=SUBSTITUTE( C6,", ", CHAR(10))With this formula the space is removed. The difference is ", " instead of ",". In the new formula there is a space after the comma.
- Thanks a lot, now it works, my bad i changed the language in english and used the wrong one 😄 Thanks for your quick help
