smeskinaoui
New Member
- Joined
- Oct 10, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
can someone help me convert this formula to VBA code:
=LOWER(SUBSTITUTE(LEFT(A1,FIND(" ",A1)+9999)," ",".")&"@XYZcompany.com")
I have a cell that has a full name (first name space last name) that I will convert to an email.
Thank you,
can someone help me convert this formula to VBA code:
=LOWER(SUBSTITUTE(LEFT(A1,FIND(" ",A1)+9999)," ",".")&"@XYZcompany.com")
I have a cell that has a full name (first name space last name) that I will convert to an email.
Thank you,