Yeah I assumed she had trailing spaces. (You know what they say about assuming.) There are no trailing spaces, because LEN(A10) = 14 and not the 16 I expected. Surprise, there's a bug in the program!

Now frankly, I think you guys are better at what I'm proposing because I'm not used to squeezing a whole bunch of logic into a single cell, as opposed to VBA, where you have all the room in the world. I suspect that you've already concluded the following, but just in case you haven't:

First name works fine. Now, if there's more than one space in the full name, then Initial and Last work fine, else Initlal is blank and Last starts with the byte following the blank found.

And I don't really care if the guy is President. If the form says "Middle Initial", then just put in one character!

I gotta change my profile. I'm more of a Mac guy now, and "Novice" makes me a bit uncomfortable, since I started programming in 1957 -- but that doesn't mean that I don't make mistakes.

It's been fun. I'm going to go watch football.