10min

Excel

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

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.





Updated 17 Sep 2020
Did this page help you?
Yes
No