How can a comma separated list be converted into cells in a column for Lt?

The instructions below can be found on the Microsoft Website.

Use the Convert Text to Columns Wizard in Microsoft Excel to separate simple cell content, such as first names and last names, into different columns.

Follow the steps below will convert coma separated list into cells in a column.

Text to Columns

  1. Highlight the column that contains your list.
  2. Go to Data > Text to Columns.
  3. Choose Delimited. Click Next.
  4. Choose Comma. Click Next.
  5. Choose General or Text, whichever you prefer.
  6. Leave Destination as is, or choose another column. Click Finish.

Two formulas in two separate columns can also be used as follows.

  To get the values to the left of the comma:  =0+LEFT(K1,FIND(",",K1)-1)

  To get the values to the right of the comma:  =0+RIGHT(K1,LEN(K1)-FIND(",",K1))

where K1 contains the initial string, such as 401.50,0.027** 0+ before the formulas converts the extracted substrings to numerical data.

Managing courses in Lt.

Students can be invited via email or imported using a .csv file. Note there are some rules for files that can be used for student import:

  1. File must be in .csv format. Click here for more information on creating a CSV file
  2. The header row of the file must contain three columns with the exact names: email, given name, family name (if using Excel, remove the commas and put one phrase in each cell)
  3. The first column of the file must contain the user email addresses. All addresses must be in the format a@b.c. For example,
  4. The second column of the file is for the given names of the users. It must have the "given name" header, but entering the names in the column is optional
  5. The third column is the family names for the users. It must have the "family name" header, but entering the names in the columns is optional
  6. The file must not have any additional columns or blank rows.