Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

This will apply this formula to the whole column and you won’t receive a #DIV/0! in any of the cells in a column. In a similar manner, you can also use the ISERROR function.