Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
Select Column A
Choose Text to Columns and choose the delimiter (most likely space or comma) "dk" wrote: 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
dk wrote:
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? Hi dk, How can you know the difference between a first and last name? E.g., James Simon Simon James |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
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 "smartin" wrote: dk wrote: 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? Hi dk, How can you know the difference between a first and last name? E.g., James Simon Simon James |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
Hi,
In C1, try something like =SUBSTITUTE(A1,B1,"") and copy down. Dave url:http://www.ureader.com/msg/10356893.aspx |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
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, In C1, try something like =SUBSTITUTE(A1,B1,"") and copy down. Dave url:http://www.ureader.com/msg/10356893.aspx |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
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 "dk" wrote: 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, In C1, try something like =SUBSTITUTE(A1,B1,"") and copy down. Dave url:http://www.ureader.com/msg/10356893.aspx |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find replace
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. "dk" wrote: 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, In C1, try something like =SUBSTITUTE(A1,B1,"") and copy down. Dave url:http://www.ureader.com/msg/10356893.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |