I do a lot of spreadsheets where the original may have a set up like this
Column A:
James Doe Jr
Jonathan Doe Jr
I need it set up with the first name in the first column and the last name and Jr put into the second column. I have tried text to columns but it puts each part of the name as...