Forum Discussion
Helper IIDeleting row where column contains text
Hi nunnc01
Assume you have table
Format->Trim (Returns the result of removing all leading and trailing whitespace from text value
text.Change type to whole number
Replace error with null
Finally, remove null.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionHi Anupa_Jayakody
Easy go to Power Query click on the down arrow in the header of the column you wish to filter. Click on those you wish to delete, and like magic, gone. The nice thing is that you will see a filter icon when it is done. You can also remove this step, or modifiy it by either clicking on X by the step or the gear icon.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Helper IThank you, but I want this to be performed every time when I add a new file, so I dont have to do this manually, and the filter should pick lines only without those specified words in the column
For example- I want to remove any row that contains "XYS" text anywhere in the cells in that column. It could be even text "XYS" is with some other words too, but need to be removed if it is there in that column