If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

This is the demonstration file to accompany the article, How to split a column using an IF() function in Excel, by Susan Harkins.