Question about formula or marco

[Gus Jae]

Hi all,
Here is what I need to do:
Column B will have a list of first names (John), Column C will have last
names (Smith).
What kind of formula or macro do I need so that I can have Column A read
"jsmith" (all lower case)?
Any ideas?
Thanks very much.

 

[Lucas]

Try this formula in Cell A1:-

=LOWER(CONCATENATE(LEFT(B1),C1))

 

[Norman Jones]

Hi Gus,

Try:

A1: =LOWER(LEFT(B1,1)&LOWER(C1))

Drag A1 down as far as needed.

 

[Gus Jae]

Thanks Lucas and Norman. Much appreciated.

Gus