Forum Discussion
Excel Mac - get external data from API - how to get only the data I want, and not extra stuff
I have a txt file (query1.txt) saved in my Excel Queries folder that contains the following text (it's displaying as a link in this forum, but in my plain txt file it's just the text): https://api.q...
Well, if that data is displayed in cell A1, you can display the data you need (9329.88) by going to the cell where you want to place the data, then using this formula: =left(A1;27;7). Try that and let me know if it worked. It should!