Contact Formula from Latest Comment Column

MHalvey

Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment.

I currently can move (1) email but not multiple ones. I then put it in a helper column to then run a report off by current user for our ticket system.

With some community searches, Here is my current formula:

=IFERROR(REPLACE(RIGHT(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1), LEN(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1)) - FIND("!", SUBSTITUTE(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1), " ", "!", LEN(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1)) - LEN(SUBSTITUTE(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1), " ", ""))), 1)) + LEFT(MID([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1), 256), FIND(" ", MID([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1), 256), 1)), 1, 1, ""), "")

Any help with this would be great. Thank you!

Michael

Paul Newcome

It is not currently possible to use a formula to populate multiple usable contacts within a single cell.

MHalvey

@Paul Newcome - Sounds good. Thank you as always for your wisdom and wealth of knowledge.