zonate_toaster
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In fact a bit simpler still:
="BLOMN - " & LOWER(LEFT(A1,1) & B1) & " - 7945_UDP"
Chris
="BLOMN - " & LOWER(LEFT(A1,1) & B1) & " - 7945_UDP"
Chris
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
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
="BLOMN - " & LOWER(LEFT(A1,1)) & LOWER(B1) & " - 7945_UDP"
Chris