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 feeds but it doesn't work.

Wrap text is of no use since the individual lines are of differing length and therefore increasing/decreasing the cell width doesn't work generically.

I don't want to have to go through 100 cells inserting ALT + Return for each line.

    • BSM2023's avatar
      BSM2023
      Copper Contributor

      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

        BSM2023 

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

         

Resources