Function to replace

  • Thread starter Thread starter cindee
  • Start date Start date
C

cindee

Here's a simple 2-step answer:

First do a find an replace on the name:
find " " (space)
replace with "."

That'll give you Bill.Smith

Then do a concatenation to add on the @ and the xxx.com
like this:

=CONCATENATE(A1,"@","xxx.com") where A1 is Bill.Smith

Good luck.
 
Thank you I will try that.

cindee said:
Here's a simple 2-step answer:

First do a find an replace on the name:
find " " (space)
replace with "."

That'll give you Bill.Smith

Then do a concatenation to add on the @ and the xxx.com
like this:

=CONCATENATE(A1,"@","xxx.com") where A1 is Bill.Smith

Good luck.
Click to expand...
 
Back
Top