Search

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!


5 views

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com