the B2 is the text you want to search in, and the C1 is the number of characters you want to return (4 or 5 or 6 etc)

the "*" is a wildcard in the match