Replacing alphabets with numbers using Power Query

HI experts,

I have a very simple question: I have got a column in my dataset which contains 2 digit numbers, but there are also rows where I have either just a string of alphabets or a combination of alphabets and numbers. All I want to do is to be able to replace cells with alphabets (and numbers) with ‘00’.
New Microsoft Excel Worksheet.xlsx (9.1 KB)
PBI file.pbix (22.4 KB)

Hello @musa.fasih

Thank you for posting your query in the forum…

Please find the PBIX file where I have replaced the text or combination of text and numbers with 00, hope it helps for you…

image

please change the source of the file to your file source.
PBI file.pbix (22.8 KB)

Thanks,
Dharmendar S

2 Likes

Thank you!