Excel formula to extract number from text

  VNAM75 15:14 18 Jan 2007

I have a multicolumn spreadsheet with data like


I need a formula to extract just the number only ie. 100 and 350. I can do text to columns but can only do one column at a time and there are a lot of columns.

  VoG II 15:25 18 Jan 2007

If the number is always 3 digits:


  VoG II 15:28 18 Jan 2007

If the number of digits could vary


  VNAM75 15:35 18 Jan 2007

VoG™, thanks the number varies and your second formula works. But I have just noticed I have another type of data



So is there a formula that would bring me what is to the right of "=" In this case "normal" and the above 100 and 350.

Sorry, just noticed after typing the above it also works for text.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique