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.

Who is Participating?
AnilData ManagerCommented:
2nd is

="NYCCS - "&A1&" "&B1&" - "&RIGHT(C1,4)

Hope this helps.

AnilData ManagerCommented:
1st request is

zonate_toasterAuthor Commented:
Great 1 st request is working as per the forumla,thanks akajohn.Looking forward for fix of second request.
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

zonate_toasterAuthor Commented:
Great second reuest i have missed it,this is also working as reqested.Great for super fast reply.Thanks aton.
zonate_toasterAuthor Commented:
i would like to give you 1 million point coz of super fast reply.
AnilData ManagerCommented:
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.

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.