Find a character and replace with a number

[Anjankumar2021]

Hi All,

please assist on the below.

Input Date:

i want to replace short name of month to number " JN/18/24 to 01/18/24, so that i can convert into proper format like MM/DD/YYYY or YYYY/MM/DD

Date

JN/18/24

FB/28/24

MY/16/24

JN/19/24

AG/31/21

MR/05/24

NV/01/23

JN/20/24

JN/14/24

JN/21/24

MR/06/17

FB/21/22

MR/28/23

MR/20/24

MY/29/24

MR/11/24

JN/17/24

SP/15/23

MY/17/23

JN/05/24

MY/31/23

JN/20/23

MY/30/24

DC/20/23

DC/21/23

OC/04/23

AP/26/24

NV/29/22

JN/12/24

MY/23/24

MY/24/24

FB/27/24

JN/06/24

OC/25/19

Date_Short Name	Date
JA	01
FB	02
MR	03
AP	04
MY	05
JN	06
JL	07
AG	08
SP	09
OC	10
NV	11
DC	12

[Anjankumar2021]

Find and replace tool gave the output. thank you

[aatalai · Accepted solution]

@Anjankumar2021 take a look at this if you want to do it with formula tool