+ Reply to Thread
Results 1 to 2 of 2

Google SHeets: Combine emoji and today fucntion

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    487

    Google SHeets: Combine emoji and today fucntion

    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
    Thanks,

    R.



  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,644

    Re: Google SHeets: Combine emoji and today fucntion

    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?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamic link to cell for ThisWorkbook.Sheets fucntion
    By RJT.123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2020, 06:57 AM
  2. [SOLVED] Auto-populate a cell with a date today [Google Apps Script]
    By Kotasyon in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 10-09-2019, 04:07 AM
  3. Auto-populate a cell with a date today [Google Apps macro]
    By Kotasyon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2019, 09:42 AM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. [SOLVED] Text and Today() function not returning date in right format (Google sheets)
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-10-2018, 12:01 PM
  6. [SOLVED] Google Sheets - Formula or conditional formatting help - a "today's date" formula?
    By Nolarobinson in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 04-25-2018, 07:09 AM
  7. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1