First we sort the column, selecting
it and choosing A to Z sort
Now we go to the Data Page, choose text
to columns and choose a blank as delimiter
Now apply the “PROPER” function to cell A1 in an empty cell and drag down. Now do the same for column 2
Free to try. No credit card needed.