How to split a column using an IF() function ... In database fashion, a lot of data is defined by type. That way, you only need one field for the actual value. You can do this with Excel, too ...

Insert a custom JavaScript function from Excel's formula database "Office developers have been wanting to write JavaScript custom functions for many reasons," Microsoft says, "such as ...