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
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.