Errors

Value error

Instead of using the normal formula use an iferror too, so The formula =B1/C1 becomes =IFERROR(B1/C1,0). The last value is the value you will show if there is nothing else

Look

Format

Show more text or less text. https://www.spreadsheetclass.com/wrap-clip-or-overflow-unwrap-text-in-google-sheets/

Conversion

Commas into columns

How to split a csv with commas into different columns?

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

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.

 www.adinstruments.com Hyperlinks to links

https://superuser.com/questions/430260/excel-convert-a-column-with-hyperlinks-to-just-display-the-links