| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to delete the first word in every cell in a column
Hi - I have a long list of names (first name and sirname) and I have just
divided this list into 2 columnes. The first column now contains the first name and I want to delete this first name from the second column (that contains both names), so that the second column only contains the sirnames....How is that possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to delete the first word in every cell in a column
You could have done it all in one operation but here you are. Select the
column with both names in and then:- data:text to columns If you follow the wizard it will split yura dat into 2 columns. As you already have a forename column delete one of those. Mike "Berit" wrote: Hi - I have a long list of names (first name and sirname) and I have just divided this list into 2 columnes. The first column now contains the first name and I want to delete this first name from the second column (that contains both names), so that the second column only contains the sirnames....How is that possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to delete the first word in every cell in a column
Also, you can tell the wizard to skip the first column, i.e., NOT import it,
which would leave you only with a single column of text. No duplicate data and no need to delete a column "Mike H" wrote: You could have done it all in one operation but here you are. Select the column with both names in and then:- data:text to columns If you follow the wizard it will split yura dat into 2 columns. As you already have a forename column delete one of those. Mike "Berit" wrote: Hi - I have a long list of names (first name and sirname) and I have just divided this list into 2 columnes. The first column now contains the first name and I want to delete this first name from the second column (that contains both names), so that the second column only contains the sirnames....How is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i delete a * at the end of each word in a column | New Users to Excel | |||
| delete middle word from a cell | Excel Discussion (Misc queries) | |||
| delete a cell if it contains specific word | Excel Discussion (Misc queries) | |||
| delete cell that doesn't contain a specific word | Excel Discussion (Misc queries) | |||
| formula to delete last word in a column | Excel Discussion (Misc queries) | |||
Linear Mode
