Removing Page Breaks from a Cell

Blair Thompson

The addition of Dropdown (Multi Select) has been very useful, but the page breaks that it includes between each selection has made formatting the strings problematic. Is there anyway to removed page breaks or replace them with a space or another character?

Paul Newcome

It is actually a line break which is also

 

CHAR(10)

.

Using the CHAR(10) reference in a SUBSTITUTE function will give you the ability to replace the line breaks.

.

=SUBSTITUTE([Multi-Select Column]@row, CHAR(10), "")

will remove the line break.

If you wanted to replace instead of remove, then the spot for that would be where you see "" in the above formula. You can put whatever you want in there to replace the line break.