djlny wrote:
I have to combine my list of almost 800 names listed as last name, first
name, with another list which has them as first, then last.

Can I somehow correct my entries to read as first then last?

Thanks much,
djlny

If you have the last name, first name in one cell I would use
data text to columns to separate them into two columns.
FirstName and LastName. Then it's just a matter of cut and paste.

gls858