Format Cells to Repeat Prefixes or Suffixes

November 22, 2018

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!

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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