https://youtube.com/watch?v=dQ36DxVTdNISeparate Numbers from text in Excel using Flash Fill - Ctrl E Amazingly useful. Also available in Power Query as Add Column By Examples. Read detailed articles on Dr Nitin's…