CODEWITHSUNDEEP
regexgoogle-sheetsemojiformulas
Ryouta11
Ryouta11

Reputation: 69

How do I count emoji and symbols in a cell?

What formula can I use to get a count of emoji and characters in a single cell?

For example, In cells, A1,A2 and A3:

🙌🙌🙌

🤜✋️👈🤜🤜

??👊👊👊

Total Count of characters in each cell(Desired Output):

3

5

5

Upvotes: 5

Views: 3185

Answers (2)

Max Makhrov
Max Makhrov

Reputation: 18717

=COUNTA(FILTER( SPLIT(REGEXREPLACE(A1,"(.)","#$1"),"#"), SPLIT(REGEXREPLACE(A1,"(.)","#$1"),"#")<>"" ))

Based on the answer by @I'-'I

Some emojis contain from multiple emojis joined by char(8205):

👨‍👩‍👧‍👦‍👦‍👆

enter image description here

The result differs and depends on a browser you use.

I wonder, how do we count them?

Upvotes: 1

TheMaster
TheMaster

Reputation: 50644

For the given emojis, This will work well:

=LEN(REGEXREPLACE(A13,".","."))
  • MID/LEN considers each emoji as 2 separate characters.
  • REGEX will consider them as one.
  • But even REGEX will fail with a complex emoji like this:

👨‍👩‍👧‍👦

This contains a literal man emoji👨, a woman emoji👩,a girl emoji👧 and a boy emoji👦-all joined by a ZeroWidthJoiner. You could even swap the boy for a another girl with this formula:

=SUBSTITUTE("‍👨‍👩‍👧‍👦","👦","👧")

It'll become like this:

‍👨‍👩‍👧‍👧

Upvotes: 3

Related Questions