I have a client who has an Excel spreadsheet with one column of names.
Each cell in that column is in the format:

LASTNAME, FIRSTNAME

He wants to take that column of entries and convert each to:



.... where XYZ.com is the same for each entry.

Is there an Excel macro that will do that? Or a VB script?

TIA