How would I go about adding a field to an existing table that already has 25,000 records and filling all 25,0000 cells in that new field with the same value, say, “Cookbooks?”

If you’re curious, it’s because my dear old dad put both general subject location data in the same cell with specific location information (i.e., Cookbooks - garage wire rack, top shelf). And before you go suggesting that I use a formula which divvies up the data before and after the dash, I should say that he’s totally inconsistent in the way he orders this information and the way he separates it.