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.7
Overall Rating
84%
9%
5%
2%
0%
Reviews
M
MRIDHA MD MERAJ
5
Very good and Thank you so much
M
Md Mujahidul islam
5
This is a very good course.
M
Md Masud Rana
5
Good job
M
MD Yasin Khan
5
very helpfully for me thanke you learn vern team member
A
Abrar Hossen
5
I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh
Share a personalized message with your friends.