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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?