How do I split Three columns?

How do I split the value of a drop down menu into a total of three columns?

The column with the drop down menu I would like the first name only to remain, the second to only contain their email and the third their phone number?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!