View Single Post
  #1   Report Post  
PM
 
Posts: n/a
Default How to extract month number from month name

I have a workbook that have multiple workshhets in it. The worksheets are
called January, February, March ..... (Please note thare are a couple of
worksheets which are not month related). Within each month sheet I have a
column that has a reference number 01 for Jan, 02 for Feb, 03 for March... At
the moment the reference numbers are typed in manually.

Is there a way where I can extract the month number from the month name and
automatically insert it into the reference number column?

Any help would be appreciated.