I have the following cells with emojis.

As you can see I would like to get the value of these emojis as numeric.

I tried using a regex: =len(regexreplace(A2,"[^\⭐️]",""))

However, I do not get the desired result.

Any suggestions what I am doing wrong? Find below the link to the example spreadsheet:

ALTERNATE FORMULA

=BYROW(IFERROR(INDEX(SPLIT(REGEXREPLACE(A2:A, "(.)", "$1|"), "|"))),LAMBDA(ax,IF(ax="",,LAMBDA(zx,IF(zx=0,"-",zx))(COUNTIF(ax,"⭐") COUNTIF(ax,"