Got a fairly large sheet circa 9k rows. In one column, each cell lists all the users email addresses assigned to them. I need to find a way to trim that down to the one email address I want shown in each cell. For instance, the cell may read like this:
Basically, for each cell in that column, I want to strip out all of the rubbish data and just be left with the X500 part.
I thought about custom importing the CSV and choosing where to place the comma in that cell, but of course, each email address is different in length, etc.
Does that make sense? If so, what's the best way to do it? I'm guessing something like a complicated mid string lookup.
Code:
X400:C=us\;A= \;P=DOMAIN\;O=Exchange\;S=Jones\;G=John\;;SMTP:[email protected];smtp:[email protected];X500:/o=DOMAIN/ou=Networks/cn=Recipients/cn=Jone26J;smtp:[email protected]
Basically, for each cell in that column, I want to strip out all of the rubbish data and just be left with the X500 part.
I thought about custom importing the CSV and choosing where to place the comma in that cell, but of course, each email address is different in length, etc.
Does that make sense? If so, what's the best way to do it? I'm guessing something like a complicated mid string lookup.