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...
=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.