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 Geogra...
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