Excel, how to find and replace multiple items at once.?

DerekV

New member
Joined
Jun 4, 2008
Messages
10
Reaction score
0
Points
1
I have a list of Disco model numbers on one sheet, and a inventory sheet with all the models numbers. I want to find all the Disco model numbers on the inventory sheet and highlight them. I know I can use the find and replace function, but I've only been able to get it to work with one item at a time. Is there a way?
 
Control + F for Find, click on the Replace tab and enter what you want replaced w/ what you'd like to see it replaced with and click Replace All.
 
Control + F for Find, click on the Replace tab and enter what you want replaced w/ what you'd like to see it replaced with and click Replace All.
 
Multiple Find and replace.

Simular to the questioning post obove;
My question is, I have a lot of models to search for. is there a way to search for several at a time? I do know the replace all will find all values matching this model. the qestion is, how do I find all the values matching THESE models? To help save time.
 
Back
Top