Forum Discussion

BSM2023's avatar
BSM2023
Copper Contributor
Feb 01, 2023

Insert line feed in concat function

I have a postal address in 5 cells in a column. I want to concatenate the data into one cell, formatted as a multi-line address. I have tried to insert ASCII characters 10 and 13 to provide line feed...
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 01, 2023

BSM2023 

1. Set the entire column to wrap.

2. Use this formula:

=TEXTJOIN(CHAR(10),,A1:D1)

 

 

  • BSM2023's avatar
    BSM2023
    Copper Contributor
    Feb 07, 2023

    Patrick2788

    Thanks for the response.

    I tried wrapping the 5 columns before trying the TEXTJOIN command. It made no difference.

    I then ran TEXTJOIN and used Wrap on the output column. The data from the source cells appeared as one string with no spaces between the original source text. I then increased the column width but the text was merely constrained by the column width and took no account of line feeds. 

    • Anthony47's avatar
      Anthony47
      Copper Contributor
      Feb 07, 2023

      BSM2023 

      You need to format the output cell with Wraptext=true into the Alignment tab

       

Resources