Extracting String Between ""


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

Any assistance would be greatly appreciated.

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.