Take Certain Text In Cell

Ask for Help
4
  1. To get 21 out of 2021, one way is to use math:
    Create another column "Split Year"which subtracts 2000 from year column (2021) to get 21,
  2. To get 03, you may create another column “Month Number” and use if-then-else to create number out of Month name “March”. For example: If Month = March, then value of Month Number is equal to 3 and so on.