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
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives