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.

     

Alex___'s avatar
Alex___
New Member
4 years ago

Hi, Yes, blank means null. 

 

I am sorry, I don't understand your comment. I only want to remova all text (e.g. S, ap, be etc.) and leave numerical values in the column

 

 

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
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.