Excel formula Question

Posted on 2011-05-11
Last Modified: 2012-05-11
Please help me write a forumula where Column C should give the value as BLOMN - oopen - 7945_UDP

A              B                  C
Open      Open            BLOMN - oopen - 7945_UDP
Leah      Felsenthal    BLOMN - lfelsenthal - 7945_UDP
Maggie      Katan           BLOMN - mkatan - 7945_UDP
Note:have BLOMN Followed by space and - lower first letter of column A followed by lower column B followed by space - 7945_UDP

Question by:zonate_toaster
    LVL 51

    Accepted Solution

    C1: ="BLOMN - " & LEFT(LOWER(A1),1) & MID(LOWER(B1),1, LEN(B1)) & " - 7945_UDP"

    copy down
    LVL 59

    Expert Comment

    by:Chris Bottomley
    Slightly simpler:

    ="BLOMN - " & LOWER(LEFT(A1,1)) & LOWER(B1) & " - 7945_UDP"

    LVL 59

    Expert Comment

    by:Chris Bottomley
    In fact a bit simpler still:

    ="BLOMN - " & LOWER(LEFT(A1,1) & B1) & " - 7945_UDP"

    LVL 51

    Expert Comment

    oops, what I posted? does not make sense, but it does what he wants :)

    it should be this.

    C1: ="BLOMN - " & LEFT(LOWER(A1),1) & LOWER(B1) & " - 7945_UDP"

    I guessed firs I understood get a part from B and add it to first letter of A

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    This article will show you how to use shortcut menus in the Access run-time environment.
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

    746 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

    13 Experts available now in Live!

    Get 1:1 Help Now