Excel formula Question

Posted on 2011-05-11
Last Modified: 2012-05-11
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.

Question by:zonate_toaster
    LVL 6

    Expert Comment

    1st request is

    LVL 6

    Accepted Solution

    2nd is

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

    Hope this helps.


    Author Comment

    Great 1 st request is working as per the forumla,thanks akajohn.Looking forward for fix of second request.

    Author Comment

    Great second reuest i have missed it,this is also working as reqested.Great for super fast reply.Thanks aton.

    Author Closing Comment

    i would like to give you 1 million point coz of super fast reply.
    LVL 6

    Expert Comment

    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.


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Match Values and Return to Cell 6 21
    Excel Averageifs 2 17
    Dynamic Bar chart in Excel 5 19
    VBA Code Error 3 8
    Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
    Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now