Extract Numbers Scattered Within Letters

In this video, Ahmed Oyelowo demonstrates how to use Power Query to isolate numbers that are in between characters and vice versa.

Watch till the end to see the different twists he introduced.

[preciousnwachuku]

Thanks a lot for sharing. There is so much to discover with Power Query

[adesojijoshua]

Awesome video. PQ is inexhaustive 👍.
With Excel, you will need at least five functions to the best of my knowledge (Sequence, Len, Mid, Iferror, Concat)