Hi. Thanks for looking at my Thread.
I have over 100k names I must combine into various formats.
For example
John Doe =
John Doe =
John Doe =
John Doe =
John Doe =

The most common format is First Name(dot)Last Name and this is the format Ill be using most.

I figured out how to do this format using this function. I slightly modify it to give me the varying results needed:

"

This will give me something like:

The problem I am having is some names in the First Name column have an middle initital. For example:
A B
1 John J Doe
So using the above formula I get:
john

I need a function that will combine the first name and middle inititial with a decimal in between, if a middle initial is present. If there is no middle initial, to continue with combining into the set format.

What I need is a formula that will take:
John Doe and/or John J Doe and create: john.doe or john.j.doe @xxx.com

I came across a formula online, closer to what I need, but it does not do exactly what I need and Im getting confused modifying it:
=IF(ISNUMBER(LEN(A1)-FIND(" ",A1)),IF(LEN(A1)-FIND(" ",A1)=1,A1&".",A1),A1)

Thank you very much!