Forum Discussion

forthaus's avatar
forthaus
Copper Contributor
Feb 12, 2023
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...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Feb 12, 2023

    forthaus 

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

     

dscheikey's avatar
dscheikey
Bronze Contributor
Feb 12, 2023

forthaus 

Then try it: (in A1 is your address)

=SUBSTITUTE(A1,", ",CHAR(10))

SIGN() is the wrong function. It gives the sign of a number.

 

  • forthaus's avatar
    forthaus
    Copper Contributor
    Feb 12, 2023
    Thanks a lot, now it works, my bad i changed the language in english and used the wrong one 😄 Thanks for your quick help

Resources