In the Split based on section, select Specific column and select the column value you wish to split the data on from the drop-down box. (If your data contains headers that you want to include in each new split worksheet, select the option My data contains headers.)
Choose which column of full names you want to separate. Select Text to Columns from the Data tab > Data Tools group. Select the Delimited option and click Next on the first step of the Convert Text to Columns Wizard. Select one or more delimiters and click Following in the next step.
To view multiple copies of the same worksheet, use Excel's split-screen functionality. Splitting the screen divides the current worksheet into two or four portions, allowing you to see the same or separate parts of the worksheet.
Learner's Ratings
4.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.