bopsoking.blogg.se - Libreoffice calc excel

Next we must delete all the extraneous rows and columns.In Microsoft Excel, select Home > Paste > Paste Values. Then uncheck "Paste all" and check only "Text". In LibreOffice Calc, select Edit > Paste Special.In LibreOffice Calc, select Edit > Cut.Ĭombined names have been cut to the clipboard.Next we must save our combined names as text, not formulas.

In Microsoft Excel, select Home > Fill > Down.

In LibreOffice Calc, select Data > Fill Cells > Down.

Select cell C8 and all the cells below it, all the way down to the last student row.

In cell C8, enter the formula =CONCATENATE(D8,", ",E8).

In LibreOffice Calc, select Sheet > Insert Columns > Columns Left.In Microsoft Excel, select Home > Insert > Insert Sheet Columns.

Select a cell in the "Last name" column.

We must combine the "Last name" and "First name" fields as follows:.

The first step is to open your csv file containing scores in a spreadsheet editor, such as LibreOffice Calc or Microsoft Excel.Ī csv file containing several assignments. Reformatting grades for Canvas Reformatting grades in a csv file for Canvas import