nesting lower case function

[carolegreg]

excel 2013, Win 7
I need to create twitter accounts for my company but cannot finalize my formula.
My formula is:
="@"&LEFT([Lastname],3)&LEFT([@Firstname],1)&"CG"
which is giving me @BerCCG. This example is for Carla Bere..."Ber"-being the 3 first letters of last name "C"-initial of first name "CG" represents the company.
The only problem with above is they want everything in lowercase except for CG.
I know LOWER is the lower case function but I am having troubles nesting it in my function.

 

[JoeMo]

Try:

="@"&LOWER(LEFT([Lastname],3)&LEFT([@Firstname],1))&"CG"

 

[Peter_SSs]

Welcome to the MrExcel board!

Try

=LOWER("@"&LEFT([Lastname],3)&LEFT([@Firstname],1))&"CG"

 

[carolegreg]

Joe,

This worked perfectly!
Much appreciated, I can finally sleep with a sound mind now