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

 

  • TomMartens's avatar
    TomMartens
    Super User
    6 years ago

    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's avatar
    maccaronda
    Frequent Visitor
    6 years ago

    Thanks!