Replace semi colon with line break / carriage return in list of contacts
I need to import a file from a legacy system that has a list of emails separated by semi-colons in a cell. In order for the emails to be recognized as 'contacts' in Smartsheet I need to replace the ";" by a line break. What would be the easiest work around?
Thanks,
Answers
-
=SUBSTITUTE(Emails@row, "; ", CHAR(10))
You'll need to turn on Word Wrap for the column with the formula (Column3 above). If you don't turn on Word Wrap it'll look like this:
-
Also, if you dont have a space after each semicolon then you'll need to remove the space after the semicolon in the formula above.
-
Thank you! That worked, but it still doesn't recognize the emails as 'contacts' (column type is set to contacts). Any thoughts?
-
Double click the column and in the Add Contacts area manually enter them there in the bar at the bottom. See if it recognizes them that way.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!