I am looking to extract a specific word in a column and only return that word otherwise blank. For example if i have multiple words in rows like:
Open
Closed
In progress
I want to show in a new column just “open”
I will then repeat to show “closed”
A...