Hello! This is my first time posting so please let me know if there is any additional information that you need from me! I'm using Professional Plus 2019. I work at a numismatic store and I want to be able to sort by the year and the grade of the coin... unfortunately, the grade words in alphabetical order don't order them correctly and it's been a thorn in our side for a long long time so it would be a big help to be able to order them by their more specific number grade instead.
This is the type of information that I am working with (main chart). I'm hoping to extract just the numbers from inside of the parentheses, not the letters. I want to specify that since some entries in the B column have parentheses with only letters. Some don't have parentheses at all (please see second chart below). I tried to FIND "(" and then FIND "-" but it kept extracting from "50-cents" rather than the one from inside the parentheses. Any help is greatly appreciated!
If there is no formula that could work here, are there other settings to only allow numbers in that column? Could I split that column in turn at the "-"? I'm not sure what other solutions I could think of. Perhaps you brilliant minds could help out this small business?
(Main chart)
(Second chart)
This is the type of information that I am working with (main chart). I'm hoping to extract just the numbers from inside of the parentheses, not the letters. I want to specify that since some entries in the B column have parentheses with only letters. Some don't have parentheses at all (please see second chart below). I tried to FIND "(" and then FIND "-" but it kept extracting from "50-cents" rather than the one from inside the parentheses. Any help is greatly appreciated!
If there is no formula that could work here, are there other settings to only allow numbers in that column? Could I split that column in turn at the "-"? I'm not sure what other solutions I could think of. Perhaps you brilliant minds could help out this small business?
(Main chart)
| Decimal That Needs Photos RIP.xlsx | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | Code | Title | Year | Grade | Pk | Dn | ||
| 2 | 50-0024 | 1871 Canada 50-cents VG-F (VG-10) $ | 1871 | VG-10 | ||||
| 3 | 50-0043 | 1872H Canada 50-cents Very Good (VG-8) $ | 1872 | VG-8 | ||||
| 4 | 50-0094 | 1898 Canada 50-cents G-VG (G-6) $ | 1898 | G-6 | ||||
| 5 | 50-0106 | 1900 Canada 50-cents About Good (AG-3) | 1900 | #VALUE! | ||||
Sheet1 | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C2:C5 | C2 | =LEFT(B2, 4) |
| D2:D4 | D2 | =MID(B2,FIND("(",B2)+1,FIND(")",B2)-FIND("(",B2)-1) |
| D5 | D5 | =MID(B5,FIND("(",B5)+1,FIND("-",B5)-FIND("(",B5)+2) |
(Second chart)
| Decimal That Needs Photos RIP.xlsx | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 167 | 50-1291 | 2014 Canada 50-cents Brilliant Uncirculated (MS-63) | 2014 | MS-63 | ||
| 168 | 50-1295 | 2014 Canada 50-cents Proof (non-silver) | 2014 | non-silver | ||
| 169 | 50-1296 | 2014 Canada 50-cents Silver Proof | 2014 | #VALUE! | ||
Sheet1 | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C167:C169 | C167 | =LEFT(B167, 4) |
| D167:D169 | D167 | =MID(B167,FIND("(",B167)+1,FIND(")",B167)-FIND("(",B167)-1) |
