How to delete the first word in every cell in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Excel Split column data 0
Seperate Names on Columns 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Use vlookup to bring back data from second occurrence of the value 1
vlookups and logical statements? 0
XL2000 CF and Comparing Lists 5
Formatted cell column in drop down list 1

Back
Top