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 t...
So I am trying to leverage this against the following string:
New voicemail in mailbox 1 from “FIRSTNAME LASTNAME” <123456789>
Using:
MID(
Subject,
FIND(
‘"’,
Subject
)+1,
(FIND(
‘"’,
Subject
)
)-(FIND(
‘"’,
Subject
)+1)
)
But all it returns is ...
