Extract a list of unique text characters/ emojis from a cell

Question

I have a text in cell (A1) like this: ✌😋👅👅☝️😉🍌🍪💧💧

I want to extract the unique emojis from this cell into separate cells: ✌😋👅☝️😉🍌🍪💧

Is this possible?

Answer 1

• You want to put each character of ✌😋👅👅☝️😉🍌🍪💧💧 to each cell by splitting using the built-in function of Google Spreadsheet.

Sample formula:

=SPLIT(REGEXREPLACE(A1,"(.)","$1@"),"@")

• ✌😋👅👅☝️😉🍌🍪💧💧 is put in a cell "A1".
• Using REGEXREPLACE, @ is put to between each character like ✌@😋@👅@👅@☝@️@😉@🍌@🍪@💧@💧@.
• Using SPLIT, the value is splitted with @.

Result:

Note:

• In your question, the value of ️ which cannot be displayed is included. It's \ufe0f. So "G1" can be seen like no value. But the value is existing. So please be careful this. If you want to remove the value, you can use ✌😋👅👅☝😉🍌🍪💧💧.

References:

• REGEXREPLACE
• SPLIT

Added:

From marikamitsos's comment, I could notice that my understanding was not correct. So the final result is as follows. This is from marikamitsos.

=TRANSPOSE(UNIQUE(TRANSPOSE(SPLIT(REGEXREPLACE(A1,"(.)","$1@"),"@"))))