Excel: SOLVED! The Strange Case of Geography Data Type Language SPILL Errors
This video is in response to a question posed in the the Comments section of a previous video. It relates to how to remove the word Language from the Official Language property of the Geography Data Type. It's a little bit of a niche use case however in explaining how to do it, I cover:
Geographic Data Type
The ARRAYTOTEXT Function
The SUBSTITUTE Function
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/qaevep4l53jqtnf...
Link to original video about Geography Data Type: • Geographic Data Type: Your Very Own G...
The formula that I used in the demo:
=SUBSTITUTE(ARRAYTOTEXT(A2.[Official language])," language","")
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #dynamicarrays #geographydatatype
Смотрите видео Excel: SOLVED! The Strange Case of Geography Data Type Language SPILL Errors онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mike Thomas 01 Сентябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 17 раз и оно понравилось 1 людям.