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.
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
Teaching technique is easy to understand. Thanks.
Very nice teaching.
REALLY HELPFUL COURSE
This is helpful how are zero to intermediate level.
very good course
zero to hero course excel
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.