H,

I need a macro that will allow me to do several find and replace
actions within a specific column. The column will have category
infromation selected by our customers from a drop down list such as
automotive, books etc. We need to then convert these to numbers so
automotive becomes 1, books becomes 2 etc.

Any ideas?


--
rachelreveley
------------------------------------------------------------------------
rachelreveley's Profile: http://www.excelforum.com/member.php...fo&userid=2138
View this thread: http://www.excelforum.com/showthread...hreadid=480663