Next, we’re going to click the cell where we want to start adding the data-in this case B2-and click “Finish.” This will add the first and last names to their respective columns. You can use any delimiter that fits your data set. In this case, we’re using comma and space because each cell in column A has a comma and a space separating the two. Delimiters are simply how the data is separated. Figure B shows the two debit values in column E.Check both the “Comma” and “Space” delimiters and then the “Next” button. In E3, enter the following expression:Ĭopy the expression to the remainder of the column. If you're working with a Table object (as I am), Excel will automatically extend the Table. First, create a new column by entering Debit in cell E2. For that reason, we'll use two different IF() expressions: One that returns debit value and one that returns credit values. There are several string functions for delimiting strings, but we need a conditional expression. Where condition is a value or expression that equates to true or false and the true and false arguments identify what happens when condition is true or false, respectively. The IF() function uses the following form: Instead, we'll use two IF() functions, one for debit and one for credit.

You can't use it to split values based on a conditional value in a second column. You might try Text to Columns first, but in this case that feature won't work because it works with a single column. If you inherit a sheet that resembles the one in Figure A, but you want a more traditional sheet where the two transaction types are in different columns, you're not stuck. We need to split the values in column D into two columns, based on the transaction types of debit and credit. LEARN MORE: Office 365 for business Why you might use the IF() function The expressions will work in the browser edition. xlsx file, but you can also work with your own data. For your convenience, you can download the demonstration. I'm using (desktop) Office 365, but you can work with earlier versions. TechRepublic and the author were not compensated for this independent review. In this article, I'll use two IF() functions to split a simple 'database' sheet into multiple columns, based on a value in another column.ĭisclosure: TechRepublic may earn a commission from some of the products featured on this page. When this happens, you can usually revamp the structure by employing a few expressions instead of creating the new structure from scratch. Windows 11: Tips on installation, security and more (free PDF)įor instance, it's not uncommon to work in a sheet that follows traditional database design rather than a financial sheet structure.Windows 11 SE: Why it's both more and less locked down than Windows 10 S.Windows Server IoT 2022 is for a lot more than Internet of Things.Windows 11 cheat sheet: Everything you need to know.

Ma excel split cells