Selected Answer
Fida
See the attached file in which I've set the autofilter on column B to a customer text filter with "does not begin with" and a text value of "0 WP". Only the other rows are now displayed. (Note that I also removed the Trimmed data column, since the autofilter would hide some rows from yout Trimmed data). You'll also see a couple of screengraps (with red outline) to show the filter selections.
You can copy the cells from there but if you want to delete those rows, set the text filter to "begins with" instead, select the entire "0 WP" rows and delete them.
Office 365 users can use the FILTER (array) function in a single cell (and it will spill over into others). In the example below, I've used SEARCH to find the string you want to exclude. If that's at the start of a cell, the return value will be 1 (but it could be another number, 2 for "40 WP..." say) or an error. The test of that =1 will return TRUE so I've used the NOT function to invert that which will exclude those cells beginning with "0 WP" from the filtered values:
=FILTER(Table1[Raw data],NOT(IFERROR((SEARCH("0 WP",Table1[Raw data])=1),FALSE)))
Hope this helps.
