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?
Bookmarks