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

"o1darcie1o" wrote:

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" wrote:

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