Forum Discussion

Copper Contributor

Jun 30, 2022

Solved

first and last name to email from one cell

Hi, I am trying to create a code to have the first and last name from a single cell to an email address with a dott in between the first and the last name. Example, Anton van der sloot --> anton.va...

Jun 30, 2022

=LEFT(C5,SEARCH(" ",C5)-1)&"."&SUBSTITUTE(RIGHT(C5,LEN(C5)-SEARCH(" ",C5))," ","")&"@email.com"

Maybe with this formula.

OliverScheurich

Gold Contributor

Jun 30, 2022

Philippevdlof

=LEFT(C5,SEARCH(" ",C5)-1)&"."&SUBSTITUTE(RIGHT(C5,LEN(C5)-SEARCH(" ",C5))," ","")&"@email.com"

Maybe with this formula.

Philippevdlof

Copper Contributor

Jun 30, 2022

OliverScheurich Is there a way to erase #value! message for the cells that aren't filled out?

OliverScheurich
Gold Contributor
Jun 30, 2022
Philippevdlof
=IFERROR(LEFT(C5,SEARCH(" ",C5)-1)&"."&SUBSTITUTE(RIGHT(C5,LEN(C5)-SEARCH(" ",C5))," ","")&"@email.com","")
You can wrap the IFERROR around the formula.