Break Full Name into three parts

[bkamlin]

I am having trouble extracting a persons name into three parts First middle Last.

Data is like this:

Smith, John

Jones, Fred

Johnson James H.

I use leftwords to pull the last name but if I use RightWords for the First name the Middle Initial gets in the way.

I would really like to gather all three fields. First middle and Last.

[EddyB]

Hi these calculations will pull out all names for you:

FirstName=

MiddleWords(Name, 2, 1)

LastName=

LeftWords(Name, 1)

MiddleName=

Case(WordCount(Name) > 2, RightWords(Name, 1), "")

Hope this helps

Ed