I'm trying to transpose last name first. likeMr. Donald J. Trump
to Trump, Mr. Donald J.
seems excel doesn't have a good way to identify "last" though regex should be able to \s\w+\z
but not managing to get that fit into the rest of the code
worked something out. replaced \z with $ and used multiple columns to concatenate as needed