Jun 30 2022 04:28 AM - edited Jun 30 2022 04:29 AM
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.vandersloot@...
Another example,
piet de herder --> piet.deherder@......
Does somebody know the code for this?
Jun 30 2022 04:37 AM
Solution=LEFT(C5,SEARCH(" ",C5)-1)&"."&SUBSTITUTE(RIGHT(C5,LEN(C5)-SEARCH(" ",C5))," ","")&"@email.com"
Maybe with this formula.
Jun 30 2022 05:01 AM - edited Jun 30 2022 05:03 AM
@OliverScheurich Is there a way to erase #value! message for the cells that aren't filled out?
Jun 30 2022 05:25 AM
=IFERROR(LEFT(C5,SEARCH(" ",C5)-1)&"."&SUBSTITUTE(RIGHT(C5,LEN(C5)-SEARCH(" ",C5))," ","")&"@email.com","")
You can wrap the IFERROR around the formula.
Jun 30 2022 04:37 AM
Solution=LEFT(C5,SEARCH(" ",C5)-1)&"."&SUBSTITUTE(RIGHT(C5,LEN(C5)-SEARCH(" ",C5))," ","")&"@email.com"
Maybe with this formula.