I am using RegexReplace which populates the necessary data and my formula is working fine but i also want to populate those values which has (Ordered but Pending) and the word before it.

My formula populates the value which has ? sign

There are some words that i want to keep as it is like starting *** PEELS and ending like ZA - Date *** that ZA and Date can be changed in Data cell.

Your help will be much appreciated.

=TRIM(REGEXREPLACE(A2,"(\*{3}.*?)(?:\s*?\.{3}DONE=>.*)?(\*{3})$","$1$2"))