I have a field which contains data such as
"Mr. and Mrs. A. B. White". I have inserted a new field named lname and I'm trying to move the last name from the first field to 'lname' without much luck. Does anyone know a technique or function for this?

Thanks