How to Split Cell Contents in Excel

Posted Date: 29-Jun-2010		Category: Others
Author: Kumaraditya Sarkar	Member Level: Silver
Rating:	Points: 8 (Rs 6)

This articles shows the steps of how to split cell contents in Excel.

Step One to Split Cell Contents in Excel

Click on the column header which you will find near the right side of the column which you are looking forward to parse.

Step Two to Split Cell Contents in Excel

Select Columns from the Insert Menu.

Step Three to Split Cell Contents in Excel

Click on the Column Header.

Step Four to Split Cell Contents in Excel

Select Text to Columns from the Data Menu. A data wizard will then appear.

Step Five to Split Cell Contents in Excel

Select the Radio Button which will be located in the Original data type section and click Next.

Step Six to Split Cell Contents in Excel

Select the item which will separate your data. It may be a space. Check if the data is correct in the Date Preview Section. If it is correct, click Next.

Step Seven to Split Cell Contents in Excel

Click each column in the aforesaid section. Determine the Data format type and click Finish. Now create a label for the new column, and you are done!

Did you like this resource? Share it with your friends and show your love!

Responses to "How to Split Cell Contents in Excel"

No responses found. Be the first to respond...

Feedbacks

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
Website:	We will link to your website, if the comment is worth keeping!
	Type the numbers and letters shown on the left.

	Next Resource: My views on mywindowsclub.com
	Previous Resource: How to reduce the power consumption of your Windows 7 Computer
	Return to Resources
	Post New Resource
	Category: Others