| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing part(s) of text from downloaded data | Excel Worksheet Functions | |||
| removing a letter to the beginning of each part number of a column | Excel Discussion (Misc queries) | |||
| Removing part of a number in Excel | Excel Discussion (Misc queries) | |||
| removing part of text string to another cell | Excel Discussion (Misc queries) | |||
| removing part of a # | Excel Worksheet Functions | |||
Linear Mode
