I have a file in CSV format. I want to be able to sort a column that has names in it. I want to be able to sort with LAST NAME, BUT WHEN I open the file in Excel, the first name, middle initial and last name are together.
Is there a way to sort out the LAST name so I can sort with last name rather than with the whole name, first name first.
Is there a way to sort out the LAST name so I can sort with last name rather than with the whole name, first name first.