Excel formula Question

Please help me write a forumula where Column C should give the value as BLOMN - oopen - 7945_UDP

A              B                  C
Open      Open            BLOMN - oopen - 7945_UDP
Leah      Felsenthal    BLOMN - lfelsenthal - 7945_UDP
Maggie      Katan           BLOMN - mkatan - 7945_UDP
Note:have BLOMN Followed by space and - lower first letter of column A followed by lower column B followed by space - 7945_UDP

Who is Participating?
HainKurtConnect With a Mentor Sr. System AnalystCommented:
C1: ="BLOMN - " & LEFT(LOWER(A1),1) & MID(LOWER(B1),1, LEN(B1)) & " - 7945_UDP"

copy down
Chris BottomleySoftware Quality Lead EngineerCommented:
Slightly simpler:

="BLOMN - " & LOWER(LEFT(A1,1)) & LOWER(B1) & " - 7945_UDP"

Chris BottomleySoftware Quality Lead EngineerCommented:
In fact a bit simpler still:

="BLOMN - " & LOWER(LEFT(A1,1) & B1) & " - 7945_UDP"

HainKurtSr. System AnalystCommented:
oops, what I posted? does not make sense, but it does what he wants :)

it should be this.

C1: ="BLOMN - " & LEFT(LOWER(A1),1) & LOWER(B1) & " - 7945_UDP"

I guessed firs I understood get a part from B and add it to first letter of A
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.