Removing part of a cell

  • Thread starter Thread starter Chad Portman
  • Start date Start date
C

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?
 
Try this:

A1 = name, first name(123456)

Enter this formula in B1:

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

Copy down as needed.
 
Back
Top