在Excel中找到前面的文本，后跟一定数量的文本

我的电子表格数据库，该数据库有两个版本，with flag和without flag。带标志的数据具有前面的字符（例如MDL，<，ND等）

这是with标志表的一部分：

这是无标记表的相同部分：

我从工作without flag表中获取统计信息（因为公式中只能包含数字）。但是我试图弄清楚我从without flag（即最小值，均值，最大值等）获得的统计信息是否最初被标记。如果是，那是什么标志？

For the first part, I can just compare the statistics from two sheets, and if they are different, it means that it was flagged.

Question: How I can find out what was the flag? (e.g. MAX, <, R, etc.)

There are more than 15 different flags. I also prefer doing it in excel formulas for sake of simplicity as this spreadsheet till now had not needed any macro.

I am thinking about something like finding the cell that the numeric part of it matches with the statistics and then extracts the non-numeric part of it.