Placing a period after a middle initial - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Placing a period after a middle initial

  1. #11
    New Member
    Join Date
    Jun 2010
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing a period after a middle initial

     
    Thanks that works awesome

  2. #12
    Board Regular
    Join Date
    Jul 2009
    Posts
    191
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing a period after a middle initial

    Have you tried the formula in my last post?

    It worked out for a sample I made.

    Keep me posted.

    Samfolds

    EDIT : Sorry didn't see you had written back

    Glad I could help

  3. #13
    New Member
    Join Date
    Jun 2010
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing a period after a middle initial

    Another question...if you don't mind

    What if I wanted to pull the middle initial out all together and also check and make sure there is a middle initial to pull.

    The same setup: Last name, first name m. or Last name, first name.

    Can you help me with a formula for that?
    I know at the beginning of this they were trying to pull the middle initial out of the center of the name not the end. Thanks,
    Nostrovia69

  4. #14
    Board Regular
    Join Date
    Jul 2009
    Posts
    191
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing a period after a middle initial

    Just need a simple modification :

    =IF(mid(A1,LEN(A1)-1,1)=" ",mid(A1,1,LEN(A1)-2),A1)

    It checks wether there is a space at the end (meaning a middle name initial). If so, it returns A1 minus the 2 last characters (aka the middle name initial and the space). If there are not any middle name initial, it returns the current name.

    Hope this will do the trick :D

    Samfolds

    EDIT : This is assuming you did not add the (.) at the end of the initial.

  5. #15
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,261
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing a period after a middle initial

    samfolds:
    I haven't tried out your formula, but if you are going to use MID starting at the first character, why not just use LEFT?

    =IF(LEFT(RIGHT(A1,2))=" ",LEFT(A1,LEN(A1)-2),A1)
    Last edited by Scott Huish; Jun 10th, 2010 at 02:23 PM.
    Office 2010/365

  6. #16
    Board Regular
    Join Date
    Jul 2009
    Posts
    191
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Placing a period after a middle initial

      
    samfolds:
    I haven't tried out your formula, but if you are going to use MID starting at the first character, why not just use LEFT?

    =IF(LEFT(RIGHT(A1,2))=" ",LEFT(A1,LEN(A1)-2),A1)
    Indeed that is a good idea. But I think the first one is ok considering it is starting on the LEN(A1)-1 character... Hehe anyway "All roads lead to Rome".

    Samfolds

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com