Posted to microsoft.public.excel.worksheet.functions
|
|
updating email addresses in cells
CONCATENATE("FirstName", ".", "LastName", ")
If you have the entire first and last names in separate fields, you can do
this all with one concatenate function. (Concatenate
")
Hope this helps.
Bill Horton
"cstwoplus" wrote:
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
|