Utilizing glide tables only. How would i utilize substitute or another function or ? to remove the commas from a joined list and replace with carriage return? So if i have this: 130 – 5" Gutter, 60 – 3x4 Down spout And I want this: 130 – 5" Gutter 60 – 3x4 Down spout How do i accompli…

I think you can create a text/template column with only a carriage return character. Then use a template column, point to the original text, change all the commas by the carriage return.

[image] How can I make available a lookup Ask for Help @22c304 , you need to get the joined list from that same relation. Just like you did with the lookup but using a joined list column. If you’re trying to format the text from this post, you can use the carriage retu…

Carriage return line break question

Ask for Help

ThinhDinh March 21, 2021, 10:56pm 3

If you’re trying to format the text from this post, you can use the carriage return as the delimiter in the join text column.

Topic		Replies	Views
Join columns and unite the results in one line Ask for Help	15	2183	January 17, 2024
Display text in seperate lines (\n) Ask for Help	8	46	November 21, 2024
Substitute or remove text from a string Ask for Help	15	1602	August 7, 2022
=SUBSTITUTE(A1, CHAR(13), " " & CHAR(13)) Excel Formula not Working Ask for Help	12	1100	May 20, 2023
Add a break in a line Ask for Help	7	442	November 10, 2023

Carriage return line break question

Related topics