Hi, 

I tried using split function and several mid strings formula but they don't account for the spaces and suffixes in the last names.

Can you assist?  Thank you,

Thanks. There is always a title, first name and surname.
The titles will always be
Dr.
Dr. & Mrs.
Miss
Mr.
Mr.& Mrs.
Mrs.
Ms.

Right now the code is showing the entire name without the titles. Is there a way to save the surname in a variable to always appear? My suggested workplan would be to save save the titles and extract the last name and then combine them in a string.
Here is the code now:
local numbervar lst := 0;
local numbervar pos;
local stringvar greeting := {table.field};
local stringvar titles := "";

//titles
pos := instr(greeting, "Dr.");
if pos > lst then lst := pos;

pos := instr(greeting, "Dr. & Mrs.");
if pos > lst then lst := pos;

pos := instr(greeting, "Miss");
if pos > lst then lst := pos;

pos := instr(greeting, "Mr.");
if pos > lst then lst := pos;

pos := instr(greeting, "Mr.& Mrs.");
if pos > lst then lst := pos;

pos := instr(greeting, "Mrs.");
if pos > lst then lst := pos;

pos := instr(greeting, "Ms.");
if pos > lst then lst := pos;

//now find the last period of the titles
pos := instr(lst, greeting, ".");
greeting := trim(mid(greeting, pos + 1)); //remove all the titles
titles := right(greeting, pos);           //save the titles for later

pos := instr(greeting, " ");   //find the space after the first name
titles + " " + mid(greeting, pos + 1)