Find and replace list with a new list value
 

I have a list of 1000 names in one sheet. I am trying to update columns in
another sheet with the same 1000 names with a * after it. For example Bill
Smith is in the list for one record and I want it to say Bill Smith*,
indicating special treatment. I can't seem to use find/replace, unless I do
it one at a time. WIth this many it seems too cumbersome and daunting.
Anyone got any ideas?

Find and replace list with a new list value
 

Greg
Say your list is in Column A starting in A1. Find some empty column,
say Column F. In F1 enter:
=A1 & "*"
Select F1. Drag it down with the fill handle through all 1000 rows.
Copy all the occupied cells in Column F.
Select A1 and PasteSpecial - Values.
Delete Column F.
Done. HTH Otto
"Greg Schmitz" <Greg wrote in message
...
I have a list of 1000 names in one sheet. I am trying to update columns in
another sheet with the same 1000 names with a * after it. For example
Bill
Smith is in the list for one record and I want it to say Bill Smith*,
indicating special treatment. I can't seem to use find/replace, unless I
do
it one at a time. WIth this many it seems too cumbersome and daunting.
Anyone got any ideas?

Find and replace list with a new list value
 

If name is in A1 enter the following formula
=A1&"*"
You can then drag the formula down to apply it to all other the other
names you wish

Find and replace list with a new list value
 

This isn't quite what I need...I've used this a ton of times, and it's
helpful. Thanks for responding...my situation is this...

I've got fields of data in one sheet that contain multiple names. I've got
another sheet in the book with names going down column A. I need to search
the first sheet for the values in column A on the second sheet. If the name
is found in sheet 1 I need the name replaced with a value of Name & "*".
This is to signify a bit of importance for that particular name. It will
also not replace the whole value in the field, I need to leave th names.

Thanks again.
Greg

"Steven" wrote:

If name is in A1 enter the following formula
=A1&"*"
You can then drag the formula down to apply it to all other the other
names you wish

Find and replace list with a new list value
 

Greg,

Assuming the Master list is in column A and the list that you are
comparing to the Master is in column C.You want to highlight those
names that occur in both lists in Column D.
- firstly sort the Master list in alphabetical order
-in Column D enter the following formula =VLOOKUP(C1,A:A,1,0)&"*" and
drag it down
- All item appearing in the master list will get the * and those not
appearing will return #N/A
Hope this is what you had in mind
Steve