Extract number from string and add zero

Originally Posted by sandy666

Col A is source for PQ.

see att. without BASE() function

I added in row 16 new value then refresh PQ table. Try by yourself

This is interesting. I never used Power Query before (hardly any other query either) but I have a feeling I will in a not too distant future. I downloaded PQ and installed but it doesn't show up under COM add-ins. Not sure what to do now.