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!


Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

​

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

​

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

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

bottom of page