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.
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.
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!
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.
Thanks Ben - very useful and needed.
You're welcome!
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.
That was a great video... and thank you for the named function!
Couldn't find the unicode for subscript "d". Does it exist? Thanks.
Thank you so much for your information!
THANK YOU FOR THIS.
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.
I can imagine! Hopefully, your colleagues find this useful. Cheers!
As I recall, It has a built in function, go to format then text then choose what you want!
In Google Docs, yes. In Google Sheets, no.
You rock! Thank you
Thank you:)
Thank you
You're welcome!
superscript is not working for me
anyways thanks
What's happening? What have you tried?
In my sheet the function CHAR is called TEKEN (Dutch translation). So lookup the function name in your own language?
@@baseneelco Hi Bas,
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!
Thanks