+ Reply to Thread
Results 1 to 5 of 5

IF Function for MI in emails

  1. #1

    IF Function for MI in emails

    Excel MVPs:

    So this is another question about figuring out emails. I have first
    name in column A, Middle Initial in Column B, and Last Name in Column
    C, and Domain in Column D. I need a formula that gives A.B.C@D If there
    is a middle initial, and A.C@D if there isnt one. Thanks again.

    Reece


  2. #2
    Die_Another_Day
    Guest

    Re: IF Function for MI in emails

    Put this in Cell D1:
    =IF(ISBLANK(B1),A1&C1,A1&B1&C1)
    Add & " " & between Cells if you want spaces
    HTH

    Die_Another_Day

    [email protected] wrote:
    > Excel MVPs:
    >
    > So this is another question about figuring out emails. I have first
    > name in column A, Middle Initial in Column B, and Last Name in Column
    > C, and Domain in Column D. I need a formula that gives A.B.C@D If there
    > is a middle initial, and A.C@D if there isnt one. Thanks again.
    >
    > Reece



  3. #3
    Elkar
    Guest

    RE: IF Function for MI in emails

    Try this:

    =A1&"."&IF(B1<>"",B1&".","")&C1&"@"&D1

    HTH,
    Elkar


    "[email protected]" wrote:

    > Excel MVPs:
    >
    > So this is another question about figuring out emails. I have first
    > name in column A, Middle Initial in Column B, and Last Name in Column
    > C, and Domain in Column D. I need a formula that gives A.B.C@D If there
    > is a middle initial, and A.C@D if there isnt one. Thanks again.
    >
    > Reece
    >
    >


  4. #4
    Die_Another_Day
    Guest

    Re: IF Function for MI in emails

    Doh! I didn't read it clearly enough sry.
    Put this in E1
    =IF(ISBLANK(B1),A1&C1&"@"&D1,A1&B1&C1&"@"&D1)


    Die_Another_Day


    Die_Another_Day wrote:
    > Put this in Cell D1:
    > =IF(ISBLANK(B1),A1&C1,A1&B1&C1)
    > Add & " " & between Cells if you want spaces
    > HTH
    >
    > Die_Another_Day
    >
    > [email protected] wrote:
    > > Excel MVPs:
    > >
    > > So this is another question about figuring out emails. I have first
    > > name in column A, Middle Initial in Column B, and Last Name in Column
    > > C, and Domain in Column D. I need a formula that gives A.B.C@D If there
    > > is a middle initial, and A.C@D if there isnt one. Thanks again.
    > >
    > > Reece



  5. #5
    Mark Lincoln
    Guest

    Re: IF Function for MI in emails

    This assumes your data is in row 1 and that there is always a first
    name and a last name:

    =A1&"."&IF(ISBLANK(B1),"",B1&".")&C1&"."&"@"&D1

    [email protected] wrote:
    > Excel MVPs:
    >
    > So this is another question about figuring out emails. I have first
    > name in column A, Middle Initial in Column B, and Last Name in Column
    > C, and Domain in Column D. I need a formula that gives A.B.C@D If there
    > is a middle initial, and A.C@D if there isnt one. Thanks again.
    >
    > Reece



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1