Forum Discussion

maccaronda's avatar
maccaronda
Frequent Visitor
6 years ago
Solved

Extract Number from column

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 ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

john_dawson's avatar
john_dawson
Helper I
4 years ago

Very elegant; thanks