Download the featured file & code here https://www.bluepecantraining.com/how-to-extract-numbers-from-text-in-excel-3-methods-power-query-vba-textjoin/

In this video I demonstrate three methods for separating text from numeric characters within a text string. The methods are:

1) Power Query - create a column by example. PowerQuery is installed by default in the more recent versions of Excel. If you don't have it, download the add-in from here https://www.microsoft.com/en-gb/download/details.aspx?id=39379

2) VBA functions

3) TEXTJOIN formula. TEXTJOIN is only available in more recent versions of Excel.
------------------------