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 turn the text in your spreadsheet into full or partial sentences. This page includes instructions for merging columns inside a spreadsheet.
Instructions
In this example, we have a spreadsheet of students who earned awards, including several students who earned multiple awards:
For this tutorial, we will combine the two awards into one cell in our spreadsheet so we can easily use the data in our story. To do this, sort the spreadsheet so that all of the rows with data in the Award 2 column are at the top, and then select a blank column in your spreadsheet:
In the blank column, you will enter a formula that references both cells containing awards. The formula will look like this:
=I2&" and "&J2&"
In this case, =I2&" inserts the contents of I2 (Award 1), and "&J2&" insert the contents of J2 (Award 2) into this cell.
Any text that falls outside of the quotation marked cells, will also appear in this cell. In the above formula, the word and will appear, creating a cell that looks like this:
Next, you should copy the formula and paste it into each additional cell where it is needed.
Then highlight the altered cells and copy them. Immediately right-click and choose Paste Special from the dropdown box. Selecting the Values option on the sub-menu will replace your formula with the actual text:
The text in these cells will now be accurate. You can then copy and paste this information elsewhere in your document if needed - typically replacing the content in the original cell (Award 1) so it can be used as a single placeholder in your story.
Note: The instructions and images on this page may differ slightly depending on your operating system and version of Excel.