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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Berit - 12 Jun 2007 10:52 GMT

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 to this Message

Mike H - 12 Jun 2007 11:18 GMT

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

> 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 to this Message

Duke Carey - 12 Jun 2007 12:38 GMT

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 could have done it all in one operation but here you are. Select the
> column with both names in and then:-
[quoted text clipped - 11 lines]
> > contains both names), so that the second column only contains the
> > sirnames....How is that possible?

Reply to this Message