Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula for Text Formatting

Topic Labels: Formulas
Solved
Jump to Solution
1468 2
cancel
Showing results for 
Search instead for 
Did you mean: 

My Current format is like this

image

I want the format to be

Shrink-General |
5 x RM-SHRINK
1 x RM-SLIP
1 x RM-BAREFOOT

What is the formula for that?

1 Solution

Accepted Solutions
Rupert_Hoffsch1
10 - Mercury
10 - Mercury

“\n” is how you add a line break. So it would be this:

"Shrink-General |"&"\n"&"5 x RM-SHRINK"&"\n"&"1 x RM-SLIP"&"\n"&"1 x RM-BAREFOOT"

See Solution in Thread

2 Replies 2
Rupert_Hoffsch1
10 - Mercury
10 - Mercury

“\n” is how you add a line break. So it would be this:

"Shrink-General |"&"\n"&"5 x RM-SHRINK"&"\n"&"1 x RM-SLIP"&"\n"&"1 x RM-BAREFOOT"

Thank you for swift reply! Solved!