Transfer Japanese date to western date

[paris]

Hi All,

I want to change Japanese date to western date format.  Could you please help. (9 is 1 digit while 10 is 2 digits ... so I could not use left function) 

21年9月限 → 1/9/2021

21年10月限→ 1/10/2021

Month          Price

21年9月限     5

21年10月限   2

21年11月限   4

21年12月限   3

22年1月限     7

22年2月限     6

All the best,

Paris

[Greg_Deckler · Accepted solution]

@paris Was able to get day or month? with this:

MonthNum = MID([Month],4,SEARCH("限",[Month])-5)

[paris]

Thank you very much! It really helped me to save my time. 

[Greg_Deckler]

@paris Have you tried using Use Locale in Power Query? Right-click column, Change Type, Use Locale. I will give this a shot in an Enter Data query and see what happens, haven't really messed with Japanese language much.