Return cells that contain numbers with recurring digits

I have a large dump of data containing in which column A has TOTAL AMOUNTS. In column B, I'd like Excel to simply say "yes" or "no" if the cell contains a number that has any digit recurring 4 times or more consecutively.
For example: if a cell contains the number 38,353.03 this would bring "no"
For example: if a cell contains the number 3,404,444 this would bring "yes"


I tried a formula using LOOKUP(SUMPRODUCT(LARGE(FREQUENCY(--MID(
but that was a disaster


so I'm at a loss