Automatic content fill-in in a new column
Hi - I need help categorizing content/ auto-fill from the column A to column B. For example, all the cells in column A with "Argentina" automatically abbreviates to "AR" in corresponding row in column B. Is there a quicker way to automatically fill in column B cells based on content of column A instead of manually typing in the countries abbreviations? Like if a cell in column A contains the word "Argentina", how can I set it up where the cell corresponding to the row of column B automatically fills in "AR"?
Another example:
All cells in column A that says "Belgium" automatically abbreviates to "BE" in the corresponding cell to the row in column B. See screenshot for example. Shortcut tips please. NO drag downs solution since this is heavy file.