I have a list of names in column A the names are entered in this format: last
name, first name(emp id)

The emp id is always a 6 digit number. I want to copy the names only from
column A to column B thereby leaving off the emp id.

Any ideas?