Extract number from string and add zero

Originally Posted by sandy666

Ex2k16 has PowerQuery & PowerPivot built-in.
PowerQuery is under DATA tab as Get&Transform

I know now, hence my wondering if I f'ed it up by downloading and installing PQ.

Originally Posted by sandy666

and classic note: update profile about Excel version

Classic "I think I stated that I will" in my previous post.

First when I tried to edit the query the formulas didn't work and I got a warning message. I ran an update on Excel and now the query functionality is there. I still get the warning message though and after some googling I found this: https://social.technet.microsoft.com...rum=powerquery
The downloadable version is newer than the one that is shipped with Excel 2016 it seems.

Anyway, I learned a ton from this, thanks Sandy!