Assuming you have a sheet with employee numbers and names listed, check out
the VLOOKUP function.

"Gary M." wrote:

Hi,
I have several Excel Spreadsheets with lists of employee numbers (ex. 12345,
12346, 12347 etc.) I would like to automatically convert those numbers to
names (ex. 12345 = Smith, John). is there some way to do this with a macro?
Any help would be appreciated. Thank you.