How to change the date format for 2 columns as mmm-yyyy by ignoring other data in the column

Help Automation Ops
,
1

how to change the date format of huge data for 2 columns as mmm-yyyy by ignoring other data in the column
if the column contains data other than date it should ignore

2

@anjani_priya
can you create a sample excel and share

3

@anjani_priya

Can you create a sample excel

4

Book1.xlsx (1.4 MB)
the line items in original file are 1,25,000…

5

Book1.xlsx (1.4 MB)
the line items in original file are 1,25,000

6

can you share solution

7

@anjani_priya

Please check on below post

Cheers!!