Learn how to separate text and numbers into columns. We will also be answering how do I separate text and numbers in a column? Or do how do I separate data in Excel into columns? We will also be looking at, how do I separate texting members? And what are the two options for separating data using text to columns in Excel br br Here the steps outline on the video. br 1) Label adjacent cells as 1, 2, 1, 2, etc. br 2) Select header.