[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

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.

0
zonate_toaster
Asked:
zonate_toaster
  • 3
  • 3
1 Solution
 
akajohnCommented:
1st request is

=LOWER(LEFT(A1,1))&LOWER(B1)
0
 
akajohnCommented:
2nd is

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


Hope this helps.

A.
0
 
zonate_toasterAuthor Commented:
Great 1 st request is working as per the forumla,thanks akajohn.Looking forward for fix of second request.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now