Find replace

  • Thread starter Thread starter dk
  • Start date Start date
D

dk

We have a column that has first names sometimes last names we have another
column with last names you would like to remove all last names from column a
which is the first names column how can we do that?
 
Select Column A
Choose Text to Columns and choose the delimiter (most likely space or comma)
 
To basic idea is if the word in the first name is the same as the last name
just
delete the word in this first name column data to text wouldn't work
because we have sometimes three words in column a sometimes 2 and sometimes 1
 
Does not seem to be working its copies from column from column a to column c,
we would like to remove the data from column a if it appears in column c
Hi,
 
Please understand that sometimes we have three words in column a and the
third word can be their last name in the first name field, sometimes the
second word is the last name, and sometimes is only a last name in the first
name field
 
Dave's method in column C, works beautifully for me. Then you'd copy and use
Paste Special, Value to copy the "fixed" names back to column A if you want.
 
Back
Top