Hi, Ray-
It may not be elegant, but here's a workaround, at least:
If your Names are all in column A, for instance, insert a new Column B
and for each name cell write this formula:
=A1 & " "
This will add a space to the end of each name entry. Then copy column
B and paste it back over itself as values, converting all the formulas
to text. This will allow you to capture a "Jr", for instance, when it
occurs in the middle of a name entry and at the end.