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
Check out the Formula Handbook template!