B
Brian Mosher
I have 2 sheets in Excel 2000. One sheet has a column for first name and a
column for last name. The other sheet has a column in the format "last name,
first name". I need to move all of the names from the sheet that has them in
separate columns to the sheet with the "last name, first name" format. What
is the easiest way to do this? There are hundreds of names so I'd rather not
have to manually put them in. I figure Excel has to have some sort of
function for this.
Thanks,
Brian Mosher
column for last name. The other sheet has a column in the format "last name,
first name". I need to move all of the names from the sheet that has them in
separate columns to the sheet with the "last name, first name" format. What
is the easiest way to do this? There are hundreds of names so I'd rather not
have to manually put them in. I figure Excel has to have some sort of
function for this.
Thanks,
Brian Mosher