if you are SURE about your calculations, this will give you those middle initial :
TrimAll ( Substitute ( Substitute ( ¶ & Substitute ( FullName ; " " ; ¶ ) & ¶ ; [ ¶ & FirstName & ¶ ; ¶ ] ; [ ¶ & LastName & ¶ ; ¶ ] ) ; ¶ ; " " ) ; 1 ; 1 )
BTW: remember that there are double first names and double last names, too !
Thank you so much for the formula. It worked, But is there some sort of if and then logic that I should be employing in case there is a title or suffix in the full name. My present calucations for do not take them into account. For example, if Jr. is present in the full name, my present calculation designates jr. as the last name. I can create an additional full name field from which to run this calculation and strip all suffixes from the name before I import the data. But I would rather not have to go through the additional work if I can write a calculation formula that will work.
Thanks again for the help.
Title = T
FirstName = F
Initial = I
LastName = L
Suffix = S
No calculation can evaluate this:
T F F F I I L L L L S
There must be an uman intervent !
BTW: you can isolate the records ( and sure those are the most part ) that have 2 words into the field FullName, so that you can easily apply your formulas.
The omitted records must be evaluated by hand.
Hi "rowing190",What you are needing to do is referred to as "text parsing". You may want to take a look at an answer I provided to another forum user...Kundinger
A search for "parsing full names" at
Brings up this page of links