I have been trying to extract the data which is pending. The data which has ? or this (Ordered but Pending). Then formula should get that whole text from the data.

I have attached a sheet