Extract Number from column

[maccaronda]

Hi there

I have a file that is messy as anything and I would like to extract the numbers out of a particular column (some have combination of numbers and text and others just numbers. The column looks like this (sorry I had to paste as plain text)

Column A

58443
SO Stage
W58843
W58843-PB

57684
SO Stage
W57684
W57684-PB

Then the final result should look like this 

Custom Column

58443

58843
58843

57684

57684
57684

Any help would be greatly appreciated!

[john_dawson]

Very elegant; thanks

[Mariusz · Accepted solution]

Hi @maccaronda 

Try this 

=Text.Select( [Column A], {"0".."9"} )

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[TomMartens]

Hey @Mariusz ,

this is a brilliant solution. I was looking for my approach, as I did not bookmark it. I'm happy that I did find your approach first, very elegant.

~Tom

[maccaronda]

Thanks!