Spreadsheets cannot be edited once they're added to Merit. Make any necessary changes to your spreadsheet prior to uploading it.
When preparing your achievement, you may sometimes find yourself needing to replace some text in bulk throughout your spreadsheet before importing your document into Merit. This page includes instructions for globally replacing text in Excel.
Instructions
In this example, we have a spreadsheet of students with abbreviations in their degree column:
For this tutorial, we will replace the abbreviated degree with the full degree the student earned. To do this, highlight the column of abbreviated text and select the Find option in the menu bar. Then choose Replace from the dropdown menu:
Pro Tip: Use Excel's Control+H shortcut to quickly access the Find & Replace workflow.
You can then enter the word or phrase you would like to find and choose a replacement for it:
Click Replace All to change every instance of the chosen text in your highlighted column to your newly selected text:
Be careful while selecting columns and replacing text, and always review your results. This feature will replace EVERY instance of your chosen text and may accidentally replace text that you intend to keep, including parts of words (if the letters match exactly). Because of this, it's best to globally replace text one column at a time.
Note: The instructions and images on this page may differ slightly depending on your operating system and version of Excel.