Names that I want to seperate would be:

John A Doe Sr.
Sandy Park Jr.
Dan A Kim
Delma J. Smith Jr.
Bon Le mont Gu (middle name: Le mont, last name: Gu)
Oscar De la Renta (last name: de la renta)

If you can also write a macro for this, please feel free to write one.

Action that I would take : select the column that contains full names

What I want the macro to do: add 4 columns to the right (First name,
middle, last, & suffix column) with missing values left blank.