Well, you have now introduced some other variations - the word "Emergency:", which may or may not be followed by a phone number, and variable-length phone numbers.

I think you would be better using some helper columns to try to get the data into a standard format (e.g. with a <colon><space> after each keyword), and then applying simpler formulae to the output from those helpers.

It would be better still to control the format of the data in the first place.

Hope this helps.

Pete