I have a list of contacts with email addresses. My client is changing their
email layout from to . I would like to
replace the jmsith with john.smith, which I can get by concatenating the
first and last name columns with a dot, but how do I get it to replace
everything up to the @ with the newly concatenated name? I tried a
combination of search, replace, etc, but I couldn't get the combo right. Any
help is appreciated.
Everything after the @ remains the same.

Thanks,
cstwoplus