Numbers for macOS: how to update a column of entries In Numbers for macOS I have a column of entries, each entry (field) is just a single word. How can I update the whole column such that each entry will look like that instead:

&lt;img src="field_content.jpg"&gt;
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).