- Thank you received: 1
How to: Import separate lines within a cell?
2 years 9 months ago - 2 years 9 months ago #10455
by brettm
How to: Import separate lines within a cell? was created by brettm
How do I import a Word spreadsheet that keeps the carriage return in each cell? Or, do I have to use an XLS spreadsheet to import from?
More details here ...
I have a rubric that has three or more separate lines in each cell so the students can understand what they achieved. For instance, in one cell:
- short text
- limited detail
- reader can follow most of the time
But, when I try to import this by pasting into a rubric ... it puts each line in a separate cell.
My workaround is to remove any pilcrows (¶) or new lines (a return arrow symbol) from my word document but that does not allow me to have comments on each line. Instead, they look like this with commas separating everything:
Short text, limited detail, reader can follow most of the time, linked personal experience arguments, started to engage and persuade through language choices.
Here is an image of the Word document I am using:
More details here ...
I have a rubric that has three or more separate lines in each cell so the students can understand what they achieved. For instance, in one cell:
- short text
- limited detail
- reader can follow most of the time
But, when I try to import this by pasting into a rubric ... it puts each line in a separate cell.
My workaround is to remove any pilcrows (¶) or new lines (a return arrow symbol) from my word document but that does not allow me to have comments on each line. Instead, they look like this with commas separating everything:
Short text, limited detail, reader can follow most of the time, linked personal experience arguments, started to engage and persuade through language choices.
Here is an image of the Word document I am using:
