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.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives