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

Would the find and replace function not do the trick?


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

try the following formula.

I supposed that your data starts from cell A1, you can change reference
according to your requirement.

=IF(A1="in
process","01",IF(A1="production","02",IF(A1="inspe ction","03")))


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

starguy Wrote:
try the following formula.

I supposed that your data starts from cell A1, you can change reference
according to your requirement.

=IF(A1="in
process","01",IF(A1="production","02",IF(A1="inspe ction","03")))


How would I apply this to an existibg column of records?
Thanks


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

Insert a new column to the right of the original data
Type that formula in the first cell
and drag down the range.

Excel will adjust the range in the copied cells.

TimmerSuds wrote:

starguy Wrote:
try the following formula.

I supposed that your data starts from cell A1, you can change reference
according to your requirement.

=IF(A1="in
process","01",IF(A1="production","02",IF(A1="inspe ction","03")))

How would I apply this to an existibg column of records?
Thanks

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

--

Dave Peterson