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%
6%
2%
0%
Reviews
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
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.