February 21, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power Query - how to remove rows where column A begins with a certain string AND column B contains certain text?

How do i cleanse the following data to filter out anything where column A starts ABC and column B is “dog”?

This would be lines 4, 5 and 8 only in the table below:

COLUMN A | COLUMN B

:--|:--

DEF123 | HORSE

BCA3211 | MOUSE

ABC3111 | DOG

ABC4599 | DOG

ZXY7765 | HAMSTER

ABC 7711 | SQUIRREL

ABC6631 | DOG

ABC6669 | CAT

Check out the full article on the original site

#rows.com

#Excel alternatives for data analysis

#big data management in spreadsheets

#generative AI for data analysis

#conversational data analysis

#Excel compatibility

#real-time data collaboration

#intelligent data visualization

#financial modeling with spreadsheets

#Power Query

#remove rows

#filter

#column A

#column B

#starts with

#filter out

#cleanse data

#certain string

#contains text

#data cleansing