How To Add Superscript And Subscript Characters in Google Sheets

Поділитися
Вставка
  • Опубліковано 28 жов 2024

КОМЕНТАРІ • 22

  • @Ofer.Sheinberg
    @Ofer.Sheinberg 6 місяців тому +4

    A tip for those of us on a Windows machine: pressing Win+. (Windows Key + Period Key) will bring up the “emoji window”; on its top row you can switch between emojis, ASCII-smileys, and Symbols; Once switched to Symbols, the bottom row has them categorized. The “Math Symbols” category (∞) has superscript and subscript numerals, as well as fraction glyphs, roman numerals (both upper and lowercase) as well as superscript numerals within parentheses or followed with a dot (both towards the bottom of the list).
    This is a rather unrelated-to-GSheets tip, as it is built-in to Windows 10 and should work everywhere.

  • @brucechristie6148
    @brucechristie6148 8 місяців тому

    Thanks Ben - very useful and needed.

  • @johncornwell1026
    @johncornwell1026 3 місяці тому

    Thank you! I'm amazed at the number of wrong answers I found first: all of them suggesting that Format > Text > Superscript is a thing; it isn't.

  • @mph0505
    @mph0505 5 місяців тому

    That was a great video... and thank you for the named function!

  • @thomasriparetti-brown3500
    @thomasriparetti-brown3500 7 місяців тому

    Couldn't find the unicode for subscript "d". Does it exist? Thanks.

  • @UfukTimurSMPPLJKT
    @UfukTimurSMPPLJKT Місяць тому

    Thank you so much for your information!

  • @HarlynOamilda-m8d
    @HarlynOamilda-m8d 7 місяців тому

    THANK YOU FOR THIS.

  • @lafamillecarrington
    @lafamillecarrington 8 місяців тому

    As an ex-chemistry teacher, I wish I'd known about this a few years ago - you wouldn't believe how much it annoyed me seeing unformatted formulae!
    I will pass this on to my younger colleagues still toiling at the chalk-face.

    • @benlcollins
      @benlcollins  8 місяців тому

      I can imagine! Hopefully, your colleagues find this useful. Cheers!

  • @Aiman3471
    @Aiman3471 3 місяці тому

    As I recall, It has a built in function, go to format then text then choose what you want!

    • @jeffrobison1291
      @jeffrobison1291 3 місяці тому +1

      In Google Docs, yes. In Google Sheets, no.

  • @PatriciaFrete
    @PatriciaFrete 5 місяців тому

    You rock! Thank you

  • @Rebeccacollister
    @Rebeccacollister 5 місяців тому

    Thank you:)

  • @PhilBoling
    @PhilBoling 8 місяців тому +1

    Thank you

  • @renojoby9750
    @renojoby9750 8 місяців тому +1

    superscript is not working for me
    anyways thanks

    • @benlcollins
      @benlcollins  8 місяців тому

      What's happening? What have you tried?

    • @baseneelco
      @baseneelco 8 місяців тому

      In my sheet the function CHAR is called TEKEN (Dutch translation). So lookup the function name in your own language?

    • @marcpennings7881
      @marcpennings7881 8 місяців тому

      @@baseneelco Hi Bas,

    • @marcpennings7881
      @marcpennings7881 8 місяців тому

      This is why I always set my Display Language to English. You can still use the Dutch Locale to have the decimal comma instead of the dot and such. Good luck, houdoe!

  • @ratral
    @ratral 3 місяці тому

    Thanks