Extracting String Between ""

[Benson_G_Munyan]

Hello!

I have seen similar posts but cannot seem to get them to work. I have the following string of text:

New voicemail in mailbox 1 from “AWESOME DUDE” <555-555-5555>

I am trying to extract AWESOME DUDE and 555-555-5555 to seperate cells.

I have tried the solution suggested here but cannot seem to get it to function, as it returns a
-1.

Any assistance would be greatly appreciated.

[Adam_TheTimeSav]

Hi Benson, try the following two formulas:

Person Name:
REGEX_EXTRACT({Name}, '"(.*)"')

Phone Number:
REGEX_EXTRACT({Name}, '<(.*)>')

And here’s a link to the base. You can duplicate the base to view the formulas within the base itself.