Extract first 3 characters in power query

I have a performance measurement worksheet with over 200 columns. Each cell contains responses such as "Yes" if met or "No" if not met. Other cells are more descriptive such as "No - missing assignment" or "Yes - late but completed". I want to ultimately converting these to mathematic values for easier calculation.

My question is how can I extract/isolate just the first 3 characters of each cell using PQ. I could split cells by column but I would end up with too additional columns. I could also "Replace" values but this can only be done by individual columns. I need to do this across 200 columns with a clean code. Any ideas?

Unpivot your data so the columns in question are now in one column. Extract the first three characters by splitting the cells or extracting. eliminate the unwanted columns and then repivot the data.