Extracting numbers from text in Excel cells is a common task that can be accomplished using a variety of methods. One simple method is to use the TEXTJOIN function to concatenate the numbers into a single string, and then use the VALUE function to convert the string to a number.
For example, the following formula will extract the numbers from the text in cell A1 and concatenate them into a single string: