Working with Special Characters in Google Sheets
HTML-код
- Опубликовано: 17 июл 2024
- bit.ly/insert-add-on - We'll explore using the CODE and CHAR functions to work with special characters in your Google Sheet. These characters include everything except letters and numbers. Triangles, arrows, currency signs, math symbols, and more.
Insert Special Characters Add-On workspace.google.com/marketpl...
After a 7-day free trial, the app is $7.
Special Characters Wikipedia - en.wikipedia.org/wiki/List_of...
Timestamps:
0:00 Intro
0:17 Copy from the web
0:55 Insert Special Characters Add-On
2:09 Use special characters in a formula
2:56 The CODE function
3:55 The CHAR function
4:20 Putting the two functions together
5:57 Make a stock tracker
#spreadsheet #googlesheets #specialcharacters 
Наука
Sir how can plot a dynamic line between strike price and line move with spot price in strike price range
Whoa, I have no idea!
You can copy/paste a triangle or other character... I've done it with this formula "=if(date($A$2;$A$3;$A7)=today();"►";" ")"
Thanks for the special chars extension though and your methodology.
Can you give a link to the sheet? I couldn't get that to work when I was trying it.
@@ProlificOaktree docs.google.com/spreadsheets/d/15eaA8lE-uLPXbvVq4yIrY2xH6jL_uLSg5g_-J6va7kM/edit?usp=sharing
Hope that works. It's part of a larger spreadsheet I developed which allows the user to change the month dynamically by changing the values in A2 and A3 according to the month and year. The highlighted days are conditional formatting for Mondays.
You're right. I just needed to put the special character in quotes since it's a string. I need to revise this video soon and repost.
@@ProlificOaktree The other observation to make is that I am in France using French formats and if the comma parameter delimiter doesn't work - it can to be a semi-colon. If you are copy pasting my formula to your own sheet in the US, you would need to change the semi-colons to commas.
Copying m3 from the web just types "m3" like normal. The number 3 is not special in any way. So that doesn't work. Also cant find a special symbol for cubic meters
What is m3?
@@ProlificOaktree cubic meter
It's not available in the add-on but you can use the function: =char(13221)
@Prolific_Oaktree Somewhat peeved that this is not a free extension not did you mention that when promoting it! I tried it once and thereafter it tolod me my trial period was over!!! NOT GOOD 👿
Hey there. Let me know if you saw that it was free anywhere and I'll get that corrected.
@@ProlificOaktree there was no fee indicated when loading it. It doesn't even ,mention a price! Besides, how long is the trial period, that wasn't specified either.
The price is on the "home page" of the app here: workspace.google.com/marketplace/app/insert_special_characters/905125624891. It is supposed to give a seven day trial period. Did that not happen? We had some difficulty getting the billing to work and perhaps there is still a kink to get worked out.
@@ProlificOaktree No, unfortunately it didn't. I opened it once then the next access blocked me out. I didn't really even get to try it out.
I'm going to look at that now. Tx for the feedback. Also, I added the price to the video description now.