Removing part of a cell
 

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?

Removing part of a cell
 

Try this:

A1 = name, first name(123456)

Enter this formula in B1:

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

Copy down as needed.

--
Biff
Microsoft Excel MVP


"Chad Portman" wrote in message
...
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?