Remove Generation Code from a Persons Name

is that what you want?

Power Query

First Name	Last Name	Middle Name		First Name	Last Name	Middle Name
Robert	Smith Jones Jr	A		Robert	Smith Jones	A
Barry	Jones Sr	Mark		Barry	Jones	Mark
Fred	Kline JR			Fred	Kline
Larry	Thomas IV	Lincoln		Larry	Thomas	Lincoln
Kevin	Bell III			Kevin	Bell
Mark	Honey Hamilton II	Hunt		Mark	Honey Hamilton	Hunt
Jerry	Post V			Jerry	Post
John	Grant VI			John	Grant
Andy	West SR			Andy	West

Here is an option with a formula.

The formula removes only the generation code when the generation code is at the end of the name. So Valdez with a V stays intact.

Please create a table with acceptable generation codes and try in E2 and copy down:

Formula:

Please Login or Register  to view this content.

You are welcome, glad to have helped .

Please consider adding reputation to all helpers, who you think they deserved because of the help provided.
If you wish, please click *Add reputation at the bottom left of their answers.