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?