Finding repeating multiple characters from a string in cell

Hi there, i'm wanting to look through a string of text in a single cell to find repeating characters.

Currently I can search for 3 repeating characters, but i'd like to be able to do it for more. See the attached file to see what I've done so far.

Any help appreciated

cheers.

Book1.xlsx

Not sure why your formula in column C only uses the range up to B391 when you have data up to B524.

Anyway, here's another way - put this in D3:

=(LEN($A$1)-LEN(SUBSTITUTE($A$1,B3,"")))/LEN(B3)

then copy down.

Hope this helps.

Pete