Separating Text and Numbers into Columns - Excel Tips and Tricks - video Dailymotion

RobertBarone

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   Here the steps outline on the video.  1) Label adjacent cells as 1, 2, 1, 2, etc.  2) Select header.  3) Ctrl+Shift+L  4) Sort smallest to largest  5) Ctrl+C, Ctrl+V on names  6) Ctrl+C, Ctrl+V on Test Results    🔗🔗 LINKS OTHER PARTS OF THE VIDEOS 🔗🔗  Separating Text and Numbers into Columns - Excel Tips and Tricks  https://youtube.com/shorts/kFr4Qb6NFDA?feature=share    Separating Text and Numbers into Columns,How do I separate text and numbers in a column?,How do I separate data in Excel into columns?,How do I separate text in numbers?,What are the two options for separating data using text to columns in Excel?,

Transcript

00:00I recently demonstrated how you can split student name and test result from one column

00:04into two separate column and someone on the comment section has replied that why don't

00:08you just put 1212 next to the raw column and just filter it.

00:13Well, I'm here to demonstrate how you can do that.

00:15The first thing you have to do is to assign 1212 to the column just next to it.

00:21Just like this.

00:22I'm going to do that quickly here.

00:25Once you're done with it, place your cursor on the header cell, the first row itself,

00:29and press Ctrl Shift L to enable the filter.

00:32Now on this 1212 column that you just added, you're going to filter based on smallest to

00:37largest and you can see that the name and the test result get separated.

00:42Highlight the name, press Ctrl C and then put it right below the student column and press

00:46Ctrl V to paste it and for the test result do the same thing, Ctrl C and Ctrl V and you

00:52can actually get rid of this and Ctrl Shift L to remove the filter.

00:56All right.

Separating Text and Numbers into Columns - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended