How to extract numbers from a cell when the position and length of the numbers are always different


I've tried splitting text with numbers in a string in a single cell but can't find a working formula.

An Item number is always available in a Item/Document Name string, but only the article Number should be copied into a separate column. The position and the amount of the number is variable. The only factor separating them is either a space or an underline.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!