Hi Angie,

You could list the 10 names you want to keep, for example in C1:C10.
Then in B1 enter this formula:

=IF(ISNA(VLOOKUP(A1,C$1:C$10,1,0)),"All Other",A1)

and copy down column B by double-clicking the fill-icon (the small
black square in the bottom corner of the cursor. This assumes that your
names are in column A.

You could then highlight all the cells with the formula, click <copy,
then Edit | Paste Special | Values (check) | OK then <Esc in order to
fix the values.

Hope this helps.

Pete

Angie wrote:

I have a list of names, 10 of which I want to keep as is and the others I
want to change to "all other" (there are too many to use find & replace).
Can I create a new column and new variable to do this?

Thanks,