Formula - Line Breaks

Kara Lumley

New:- give this one a try 

Use CHAR(10) to enter a line break in your formula when joining text (make sure word wrap is enabled). 

=JOIN([Address1]1:[City, State, Zip]1, CHAR(10))

Andrée Starå

Hi Kara,

Thanks!

Excellent news! This function will make it so much easier to create line breaks.

Best,

Andrée

Paul Newcome

This is great. I'm going to be playing with this to see if I can find some other ways to take advantage of it.

bmarko

Can't seem to delete this request, so disregard my comments

Paul Newcome

CTRL+Enter does work. The above formulas and eventually the CHAR(10) function allow it to be used in a formula as a delimiter. If manually entering data though, CTRL+Enter does in fact work.

carriej2

CRTL+Enter doesn't work for me. I wish it were simple like Excel's Alt+Enter. I don't want to have to fuss with a complicated formula to make a list within a cell. I also don't want to have to type out all the lines and then join them into another cell. That takes way too much time and effort when a couple of key strokes will do.

Andrée Starå

It should work.

Where are you trying to use it? Which kind of column?

Margarita Takou

I am trying to do the reverse from what is being discussed here: Substitute line break with something that can be understandable on a query to url process. Can someone help?

Andrée Starå

Hi @Margarita Takou

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

M Underbrink

Strange - I can get the substitute portion of the equation to work alone in a column, but I'm getting a syntax error in the following context,

=IF(NOT(ISBLANK([Training Credits to be Issued]@row)), "Training SKU Fulfillment ID: " + [Row ID]@row + SUBSTITUTE(LineBreakHelper$1 , "-", "") + "Opportunity: " + [Opportunity ID]@row, "")

M Underbrink

Ah nevermind - I was able to get it to work with the new CHAR(10) option. (just needed to read further down the thread!)

Heather Hutchens

CTRL+ALT and CTRL+ Enter only work for me if the cell is active.

ACTIVE

VS. INACTIVE

Any ideas on how I can get it to persist?

Andrée Starå

Hi @Heather Hutchens

You’ll have to enable the Wrap feature from the menubar.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Robert Riddle

https://community.smartsheet.com/discussion/comment/168771#Comment_168771

Kara,

Thanks for putting this in the thread, you just help future me 2 years ago 😆... I used UNICHAR(10) for windows today.... again, thank you for the knowledge sharing.

Michael Halvey

Hello! I am working on a similar idea to everyone's post here. Taking multiple cells in a row and joining them together but wanted each cell information to be on a new line. I have completed the formula using the first method of the Helper column (in sheet summary) using this cell idea:

My only hiccup I have is with columns that use Multi-Select Dropdowns, the above method will move my cell data down an additional row. See Metal Type: and Finish Type: - their respected cell data sits below since they are Multi-Select Dropdowns. I switched them to Single Select, and then the cell data moves back up to the top, next to each descriptive words. Does anyone have a potential workaround for Multi-Select Dropdowns in this instants?

I did try using the CHAR(10) method and seems to be similar issue as well.

Thank you for your help,

Michael