View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Schmitz Greg Schmitz is offline
external usenet poster
 
Posts: 1
Default 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?