Excel formula to extract number from text

  VNAM75 15:14 18 Jan 07
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 07

If the number is always 3 digits:

=RIGHT(A1,3)

  VoG II 15:28 18 Jan 07

If the number of digits could vary

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

  VNAM75 15:35 18 Jan 07

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced