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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives