Hi everyone,

I would like to be able to have the following happen in an Excel Sheet (Sheet 1)

Column A3 to A30 = First Name (First Letter Always capital - remaining lower case)
Column B3 to B30 = Last Name (First Letter Always capital - remaining lower case)
Column C3 to C30 = Username (All Lower Case - first initial of first name and full last name format)

Anything entered into Column "D" is mirrored in Column "E".

Thank you so much for looking at this, I appreciate any help I can get.

Regards,
Jonathan