I have a column with the following text entries:

in process
production
inspection

There are several thousand records

I would like to be able to create an if/then formula and apply it to
the entire column that makes the following changes:

if "in process" then "01"
if "production" then "02"
if "inspection" then "03"

Can this be done?

Thanks!


--
TimmerSuds
------------------------------------------------------------------------
TimmerSuds's Profile: http://www.excelforum.com/member.php...o&userid=35596
View this thread: http://www.excelforum.com/showthread...hreadid=553661