Removing part of a cell

[Chad Portman]

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?

 

[T. Valko]

Try this:

A1 = name, first name(123456)

Enter this formula in B1:

=LEFT(A1,LEN(A1)-8)

Copy down as needed.