| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find values in one list that do not appear in a second list | Excel Discussion (Misc queries) | |||
| Find Replace list empty | Excel Discussion (Misc queries) | |||
| replace results from list with corresponding list | Excel Worksheet Functions | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Threaded Mode
