Forum Discussion

Alex___'s avatar
Alex___
New Member
4 years ago
Solved

Replace All Letters / Text to Blank in Column

Hi,   How can I replace all text (all letters) in a column in Power Query to Blanks for multiple cells at the same time?   The column contains both letters and numbers but not combined, the cell ...
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Alex___ ,

     

    Please try the code.

     

    = Table.SelectRows(#"Changed Type", each Value.Is(Value.FromText([Column1]), Number.Type))

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Alex___ , if blank means null,

 

you can use all small null in replace and replace it power query