The day I discovered “=RIGHT()” formula
4 min readAug 18, 2022
Ok: I am faced with a huge database, with 638,655 rows. I need to analyze population evolution data in all the municipalities of Spain to write a journalistic story.
I still haven’t decided the story (Which is the fastest growing municipality? Why? What percentage of women and men are there in each one?). But I found the process of cleaning the data interesting enough to share with you.