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

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!