I have exported data from an employee database that lists the employees by
an ID number. I'd like to replace that number with the employee's name
programatically.

Also I'd like to replace the category column with a number between 1 and 5

Employee Category
59 Administrative\Purchase Order Request
223 Server\Exchange

.... would become

Employee Category
Smith, Joe 5
Davis, Mike 3

I know that there is a Microsoft code sample out there for converting
monetary amounts ($3.43) to how they are spelled out "three dollars and
forty three cents". I need something kinda similar to that.

Much obliged for anyone who can point me in the right direction.

Thanks,
JM