Flash-fill a column similar to Ctrl+E function in excel

I am looking for a solution similar to the Ctrl+E flash-fill feature in Excel, or a formula to extract just what I need into another column for export.

For example, I need a column that has information set up like "101 - Class Listing" to have a column lined up next to it that has the "101" extracted (all in the same row).



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!