top of page

Format Cells to Repeat Prefixes or Suffixes


Here's a simple little tip for Thanksgiving. You can format cells in an Excel spreadsheet to show a prefix or suffix every time text is entered.

Right click on a set of columns and rows, and select Format Cells. Choose 'Custom' in the category column, and enter

"Turkey and "@

OR

@" and Turkey"

. . . as necessary. Each time an entry in made in the cell what you type will include the 'mask' that has been designated.

Enjoy your Thanksgiving!


bottom of page