Removing Page Breaks from a Cell
Comments
-
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.
-
Thank you so much!
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives