How to Use Text to Columns in Excel for Date (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

While using Excel, you may need to use the text-to-columns option in Excel. This option can be used for many activities. In this article, I will show you how to use text to columns in Excel for a date. I will show three easy steps here with the necessary illustrations. Hopefully, this article will enhance your Excel skills. I hope you will enjoy the article.


How to Use Text to Columns in Excel for Date: Step-by-Step Procedures

From here, I will describe the steps on how to use text to columns in Excel for a date. The steps are going to be described next. First, you need to create a dataset. I will show my dataset in the next step. Then, you need to use the text-to-column option. Consequently, you will find the desired result in the last step. Please follow the whole procedure step by step and inspect the illustrations for better understanding.


Step 1: Create a Dataset

  • I created a dataset here. The dataset has three columns B, C, and D called Product Name, Date, and New Dates. The dataset ranges from the B5 to the D10

Dataset of how to use to columns in excel for date

  • After creating the dataset, select the C5 cell.
  • After that, go to the Home tab in your toolbar.
  • Then, select the Number.
  • Hence, you will find the cell is under the General option.

how to use to columns in excel for date


Step 2: Use Text to Column Option

  • Now, go to the Data tab in your toolbar.
  • Then, select the Data Tools options.
  • After that, select the Text to Columns option.

Use of Text to Column how to use to columns in excel for date

  • You will get the wizard window like the picture shown below. Select the Delimited option.
  • Then, press the Next option.

Use of Text to Column how to use to columns in excel for date

  • In the next pop-up window, you will find the Tab option. Uncheck it.
  • After that, press the Next button again.

Use of Text to Column how to use to columns in excel for date

  • Now, select the Date option.
  • Then, make the destination to the D5 cell.
  • Hence, click the Finish option.

Use of Text to Column how to use to columns in excel for date

Read More: How to Convert Text to Columns in Excel


Step 3: Final Result

  • As a result, you will find the final result like the picture given below.

Result of how to use to columns in excel for date


How to Convert Date Format in Excel

While working on an Excel worksheet, you sometimes may need to change the date format of any date entries. Excel allows you to convert date format by using some small and handy steps. In this portion of this article, I will show you how to convert the date format in Excel. I will consider the previous result of the dataset as my new dataset. Follow the procedures step by step.

how to use to columns in excel for date

Steps:

  • First, select the cells from C5 to C10.

how to use to columns in excel for date

  • Then, press the CTRL+1 A pop-up window will be opened.
  • After that, select the Date option from the left side of the window.
  • Here, in the Types box, you will find different types of date formats. Then, select any one format of them.
  • Then, press OK.

how to use to columns in excel for date

  • At last, you will find the result just like the picture given below.

how to use to columns in excel for date

Read More: How to Convert Text to Columns Without Overwriting in Excel


How to Separate Date from Text in Excel

Sometimes, while working on an Excel worksheet, you may need to separate the date from the text. In this portion of this article, I will show you how to separate dates from Excel. I will consider a different dataset here. You will find the dataset below. In the first column, you will find texts with dates and in the second column, I will separate the dates from the texts. Let’s follow the steps one by one.

Steps:

  • First, select the cells from B5 to B10.
  • Then go to the Data tab of your toolbar.
  • After that, select the Data Tools option.
  • Hence, select the Text to Columns option.

  • A window will pop up. Then, select the Delimited option.
  • Then select the Next option.

  • Select the Space check box.
  • Then, click on the Next option.

  • Click on the mentioned option in the next window.
  • After that, select the C5 cell as a destination.

  • Consequently, you will find the result just like the picture given below.

Read More: How to Convert Text to Columns with Multiple Delimiters in Excel


Things to Remember

  • You should bear in mind that the default date format in Excel is mm/dd/yyyy. So, make the dataset according to the format.

Download Practice Workbook

Please download the workbook to practice yourself


Conclusion

In this article, I have tried to explain how to use text to columns in Excel for a date. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles


<< Go Back to Excel Text to Columns | Splitting Text | Split in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo