nesting lower case function

carolegreg

New Member
Joined
Nov 14, 2015
Messages
2
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.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,611
Office Version
365
Platform
Windows
Welcome to the MrExcel board!

Try

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

carolegreg

New Member
Joined
Nov 14, 2015
Messages
2
Joe,

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

Forum statistics

Threads
1,085,242
Messages
5,382,530
Members
401,791
Latest member
BJSinger7623

Some videos you may like

This Week's Hot Topics

Top