Wondering if anyone can help me out here...I have a file where in one cell, it has the Full Name and their email address. What I would like is to just capture on the adjacent cell, the name before the @ symbol within the email address. Would it be possible?
So the end look would be this:
John Smith (email@example.com) jsmith
Thanks for your help, and please let me know if you need additional info/details...