You’ll need a new column for each piece of data you want to split. Start by creating new columns beside the cell you want to split (doesn’t have to be directly beside). Of course, things get more complex when you’re dealing with middle and hyphenated names. For instance, if you’re splitting names, you’ll need one formula to grab the first and another to grab the last. The exact formula will vary based on how you’re splitting the cell. You’ll need to use the LEFT, RIGHT, MID, LEN, and SEARCH functions to split cells in Microsoft Excel. If you need something more robust than Text to Columns, there is another option. Select “Flash Fill” to auto-fill the column. If so, drag the corner down to fill the empty column for as long as you need it. Click it and choose “Flash Fill.” Ensure it grabs the correct data from the next cell. Drag the bottom-right corner of the cell down to the next one.
