Excel formula to extract number from text

  VNAM75 15:14 18 Jan 2007
Locked

I have a multicolumn spreadsheet with data like

record_id=100
caller_id=350

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:

=RIGHT(A1,3)

  VoG II 15:28 18 Jan 2007

If the number of digits could vary

=RIGHT(A1,LEN(A1)-FIND("=",A1))

  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

eg.

Status_id=normal

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