zonate_toaster
asked on
Excel formula Question
First Request:-
I have to write a formula where i can do below,concatenate columan A and Column B,take first initial from Col A in small letter and concatenate it with all the small letter of column B and show the result in Column C like below:-
A B C
Catalina Londono clondono
Hector Machado hmachado
Luis Cruz lcruz
Second Request:-
I have to write a formula where in Column D NYCCS is the first word followed by space and - A1 B1 followed by space - last 4 digit of column D as mentioned below.
A B C D
Catalina Londono 2101604113 NYCCS - Catalina Londono - 4113
Hector Machado 2101604160 NYCCS - Hector Machado - 4160
Luis Cruz 2101607889 NYCCS - Luis Cruz - 7889
Thanks for your help in advance.
I have to write a formula where i can do below,concatenate columan A and Column B,take first initial from Col A in small letter and concatenate it with all the small letter of column B and show the result in Column C like below:-
A B C
Catalina Londono clondono
Hector Machado hmachado
Luis Cruz lcruz
Second Request:-
I have to write a formula where in Column D NYCCS is the first word followed by space and - A1 B1 followed by space - last 4 digit of column D as mentioned below.
A B C D
Catalina Londono 2101604113 NYCCS - Catalina Londono - 4113
Hector Machado 2101604160 NYCCS - Hector Machado - 4160
Luis Cruz 2101607889 NYCCS - Luis Cruz - 7889
Thanks for your help in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great 1 st request is working as per the forumla,thanks akajohn.Looking forward for fix of second request.
ASKER
Great second reuest i have missed it,this is also working as reqested.Great for super fast reply.Thanks aton.
ASKER
i would like to give you 1 million point coz of super fast reply.
Glad I could help. Just make sure you do not have spaces (leading or trailing) in your data. as the formula would then fail and it would need a bit of a trim() function to correct it.
A>
A>
=LOWER(LEFT(A1,1))&LOWER(B