Sort 2 lists - one w/ last, first name // one w/ first, last name

[musicgirl]

I have 2 very large excel files that have pulled employee name, week ending
and hours information. The information comes from 2 different systems. As a
result, the names are not input the same way. I need to combine both lists
and make sure that they mirror one another. Is that possible using a macro
or sorting by "matching"?
Ex. AGARWAL NIMISH, 10/1/2004, 20 hours // NIMISH R AGARWAL,10/1/2004, 20
hours

 

[Jim]

y dont u try with SORT, it can be done and doesn;t seem to that difficult.
Provide with the file ora good example in a more explanatory way

 

[o1darcie1o]

Insert a column to the right of the names without middle initials. hi-lite
the column of names, go to Data/Test to Columns.... Choose delimited and
space as your delimiter. That will put the first & last names in two
different columns. You can then sort by either first or last name.
Hope that helps.
Darcie

 

[musicgirl]

THAT HELPED SO MUCH!!!! THANK YOU!!!

Insert a column to the right of the names without middle initials. hi-lite
the column of names, go to Data/Test to Columns.... Choose delimited and
space as your delimiter. That will put the first & last names in two
different columns. You can then sort by either first or last name.
Hope that helps.
Darcie