Google SHeets: Combine emoji and today fucntion

[rayted]

Hi guys,

How can I create this in a cell on google sheets:

📅 Saturday 7th November

i want the emoji and a today() function.

Please help!

Thank you so much

[MrShorty]

Assuming Google sheets supports emoji unicode characters the way LO calc does:

1) Somehow come up with the character or character code number you want to include. LO calc's UNICODE() function suggests that you are using character 128197 (hex 1f4c5) Unicode character list, if it will help: http://unicode.org/emoji/charts/full...ist.html#1f4c5

2) If you have the code number, you can use the UNICHAR() function to display the character. =UNICHAR(128197) will return the specified emoji character.

3) Use the TEXT() function to get the appropriate text string from the TODAY() function =TEXT(TODAY(),"ddd d mmmm")

4) Concatenate the two text strings together. =UNICHAR(...)&TEXT(...) or =CONCATENATE(UNICHAR(...),TEXT(...))

Will something like that work for you?

[Haluk]

@MrShorty,

For Google Sheets, we can use the unicode characters such as;

Calendar:

Please Login or Register  to view this content.

Push pin:

Please Login or Register  to view this content.

Hammer:

Please Login or Register  to view this content.

.....
...