Blog

Ajay Anand

Formula to extract ‘nth’ word from a sentence

Following is the formula to extract the nth word from the sentence present in the cell A1. Change the value of n in the following formula to extract the word of your choice. =TRIM(MID(SUBSTITUTE($A1,” “,REPT(” “,LEN($A1))), (n-1)*LEN(A1)+1, LEN(A1))) To extract the 3rd word from the sentence present in the cell A1, the formula should be =TRIM(MID(SUBSTITUTE($A1,” “,REPT(“…

Ajay Anand

Import data from Google Maps to Excel

Places marked in Google Maps can be exported as KML files and these files can be viewed or edited in Excel or any other text editor. Let me explain the process of adding 6 Municipal Corporations of Kerala to a personalized Map in Google and exporting that data into Excel Login to google.com.mymaps Click on Create a New…