Replace semi colon with line break / carriage return in list of contacts

MarieM

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,

Mike TV

@MarieM

=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:

Mike TV

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.

MarieM

Thank you! That worked, but it still doesn't recognize the emails as 'contacts' (column type is set to contacts). Any thoughts?

Mike TV

@MarieM

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.