Remove rows below text

omezquita

New member
Joined
Apr 1, 2016
Messages
19
Reaction score
0
Points
0
Website
www.masterdataanalysis.com
Excel Version(s)
2016
Hi,

I know how to remove a certain number of rows from the bottom of a file.

Is there a way to remove all rows below a text.

For example, I want to remove all the rows below the row that contains the text "Appendix".

Thanks!
 
There are probably several ways to do this, but here's the first I thought of and it seems pretty clean:


  1. Add a new custom column with the formula =if Text.Contains([ColumnNameToCheck], "Appendix") then 1 else null
  2. Select the new column and go to the Transform tab -> Fill Up. That will leave everything below the first Appendix with a null value
  3. Filter the new column to remove null values
  4. Delete the new column since you no longer need it
 
Back
Top