I have a sheet that contains Email metadata. The data looks like this:
https://ethercalc.org/houk0a1zt3
The end goal is to take an email header that looks like: LASTNAME, FIRSTNAME[FIRST.LAST@example.com]
And convert it to only: LASTNAME, FIRSTNAME.
Problem is that there are many different...