Numbers for macOS: how to update a column of entries
You can do it by adding an extra column and using a formula in this column. Press = key on the keyboard to open the formula window and enter the formula:

Then press the green button and copy paste the formula in other cells:


You can copy and paste the data into the original column afterwards (but use "Edit" - "Paste Formula Results" command this time).