Thanks:  0
Likes:  0

# Thread: Placing a period after a middle initial

1. ## Re: Placing a period after a middle initial

Thanks that works awesome

2. ## 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

3. ## 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. ## 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. ## 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)

6. ## 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

#### Posting Permissions

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