I have a column in excel with names that show for example WHITE, MARY I
want to change the names in the column to show the last name in one column
and the first name in the second column. I also want to change from all caps
to just the first initial in the last name and first name capitalized.
Also, can I change the whole column at once?