Get first Unicode character in Google Sheet-CodePudding

Home > Software design > Get first Unicode character in Google Sheet

Get first Unicode character in Google Sheet

Time：01-26

I want to get the first character from a string in a cell.

"Left" function seemed to worked fine, but it returned questions for emoji.

CodePudding user response：

To extract the first one:

=REGEXEXTRACT(A1,"^.")

Unicode of first value:

=UNICODE(REGEXEXTRACT(A1,"^."))

CodePudding user response：

For me the solution were to use

=char(code(A1))

code - returns the first char unicode value and then I convert it back.