Formula to extract first name for Empl Nm Column



Please excuse my beginner's question.

Is there a formula to extract the first name from an Name Colum with Last, First Mid Initial format?

ie. Doe, John A

Thank you in advance for your help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!