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

     

Mariusz's avatar
Mariusz
Community Champion
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

 

maccaronda's avatar
maccaronda
Frequent Visitor
6 years ago

Thanks!