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?
|