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
82%
10%
4%
3%
1%
Reviews
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.
S
Souvik Dutta
4
very good course
R
Raj
5
zero to hero course excel
K
KAUSHIK PAUL
5
outstanding class, mind-blowing practical class and concept. I just love it and thank you very so much.
again Thank you sir and Thank you Madam.
Share a personalized message with your friends.