Goals for today:
- Figure out why excel is suddenly retarded.
- Geocode 2487502945879 meter addresses, many of which are just street names. They are split into 8 excel tabs, two excel workbooks, and are all to be geocoded separately.
At 830 I figured out what’s wrong with excel. In yesterday’s post, you notice the text is trying to eat itself:
Well, it turns out there’s a simple solution… And it’s not overwriting. If you right click and check the formatting, it appears to be related to the text direction. It was set to ‘context’ when it should be set to ‘left-to-right’.
Problem solved. Great way to mess with your pesky coworkers though.
But it wouldn’t be GIS if there weren’t a new problem to deal with every 5 minutes, sending you farther and farther backward in your attempt to find an answer.
But then I learned a new trick with Excel. Finding the cells guilty of emptiness is simple with the Go To Special feature under Find and Select. Choose blanks and you can fill those nihilistic values with your heart’s desires.
And now we wait…