Hey guys, I have a 15000 row sheet I'm trying to edit and keep getting stuck. I have a column of numbers 1-33 which correspond to certain names of departments. So basically I need a find and replace that will search for exact numbers like so:
1 - Handguns
2 - Used Handguns
3 - Used Long Guns
4 - Tasers
5 - Sporting Long Guns
6 - Not Used
7 - Black Powder Firearms
8 - Scopes
9 - Scope Mounts
10 - Magazines
11 - Grips/Pads/Stocks
12 - Soft Gun Cases
13 - Misc. Accessories
14 - Holsters
15 - Reloading Equipment
16 - Black Powder Accessories
17 - Closeout Accessories
18 - Ammunition
19 - Not Used
20 - Flashlights & Batteries
21 - Cleaning Equipment
22 - Airguns
23 - Knives
24 - High Capacity Magazines
25 - Safes/Security
26 - Safety/Protection
27 - Non-Lethal Defense
28 - Binoculars
29 - Spotting Scopes
30 - Sights/Lasers/Lights
31 - Optical Accessories
32 - Barrels/Choke Tubes
33 - Clothing
34 - Parts
35 - Slings/Swivels
36 - Electronics
37 - Not Used
38 - Books/Software
39 - Targets
40 - Hard gun Cases
41 - Upper Receivers/Conv Kits
42 - Not Used
43 - Upper/Conv Kits-High Cap
I keep running into issues where it uses parts of the input ie; using just the 3 out of 34. It wouldn't be an issue to create a second column using if/then either. Any ideas? I've worked myself into a black hole and thought y'all might have some fresh ideas. Thanks!