3 variable find and replace

Giganews Newsgroups
Subject: 3 variable find and replace
Posted by:  ncspndoc
Date: Fri, 30 Jun 2006

I am working on a spreadsheet where I have a need to find 3 different items
and replace them with the first item as follows:

Smith
A
B
C
Jones
A
C
Green
B
C

It needs to come out like this:

Smith
Smith
Smith
Smith
Jones
Jones
Jones
Green
Green
Green

Any thoughts?

Thanks in advance for all insights and help.

Replies