How to Convert Month Name to Number in Excel (5 Suitable Ways)

In terms of working with Microsoft Excel, we might face the necessity of converting month name to number. There is no need to panic. We can do it quite simply. For this, we just need to follow some sequential procedures. In this article, I am going to discuss 5 effective ways on how to convert month name to number in Excel. I hope it will be easy to understand and then, apply later.


Download Practice Workbook


5 Suitable Ways to Convert Month Name to Number in Excel

There are so many quick, effective, and simple ways to convert month name to number. I am going to discuss 5 of them in this article.

For more simplification, I am going to use a dataset where I have some month names in a column with a serial number column. I am going to convert the month name to number in the Month Number column.

 Excel Convert Month Name to Number


1. Use MONTH Function

We can use a built-in function named the MONTH Function to convert month name to number. Just follow the following steps to execute the purpose.

Steps:

  • Select a preferred location first. I have chosen cell D5 for this purpose.
  • Next, input the following formula in that cell.
=MONTH(C5&1)

Use MONTH Function

  • Press ENTER to have the converted output.

Excel Convert Month Name to Number

Excel Convert Month Name to Number

Read More: Convert 3 Letter Month to Number in Excel (8 Suitable Methods)


2. Combine MONTH & DATEVALUE Functions

A combination of MONTH and DATEVALUE functions can be another effective way to convert month name to number.

Steps:

  • Pick a cell and write the formula mentioned below in that cell.
=MONTH(DATEVALUE(C5&1))

Combine MONTH & DATEVALUE Functions

  • After that, hit the ENTER button.

  • AutoFill the rest cells.

Excel Convert Month Name to Number

Read More: How to Convert Date to Number in Excel (4 Methods)


3. Apply MONTH Function with Symbol

In order to convert month name to number, we can also apply the MONTH function with Double Hyphen (–) symbol. You can follow the following procedure to do it perfectly.

Steps:

  • Firstly, select a cell and input the formula mentioned below in that cell.
=MONTH(--(C5&1))

Apply MONTH Function with Symbol

  • To have output, press ENTER.

  • For the remaining cells, use AutoFill.

Excel Convert Month Name to Number

Read More: How to Convert Date to Week Number of Month in Excel (5 Ways)


Similar Readings


4. Adopt MATCH Function

The MATCH function can be another handy function to convert month name to number. Just follow the following steps in a sequence.

Steps:

  • Select a preferred location first. I have chosen cell D5 for this purpose.
  • Next, input the following formula in that cell.
=MATCH(C5,{"January","February","March","April","May","June","July","August","September","October","November","December"},0)

Adopt MATCH Function

  • Next, press ENTER.

  • Lastly, apply AutoFill for the remaining cells.

Excel Convert Month Name to Number

Read More: How to Convert Text to Number with Excel VBA (3 Examples with Macros)


5. Use TEXT Function

We can also use the TEXT Function to fulfill our purpose of converting month name to number.

Steps:

  • Pick a cell and write the formula mentioned below in that cell.
=TEXT((C5&1),"m")

Use TEXT Function

  • Along with that, hit the ENTER button.

  • Finally, use Fill Handle to AutoFill the rest cells.

Excel Convert Month Name to Number

Read More: How to Convert Text to Number Using Formulas in Excel


Practice Section

For more expertise, you can practice here.

Excel Convert Month Name to Number


Conclusion

At the end of this article, I like to add that I have tried to explain 5 effective ways on how to convert month name to number in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo