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	14	2194	January 26, 2021
Display text in seperate lines (\n) Ask for Help	7	85	November 14, 2024
Substitute or remove text from a string Ask for Help	14	1614	August 6, 2022
=SUBSTITUTE(A1, CHAR(13), " " & CHAR(13)) Excel Formula not Working Ask for Help	11	1111	May 19, 2023
Add a break in a line Ask for Help	6	451	November 10, 2023

Carriage return line break question

Related topics