earth

  1. M

    Opening a KML file into an Excel Data Map

    I am able to open a KML file in Google Earth and Google Earth will provide me a map of boundaries for geographical entities, like counties. Is there a way I can open a KML file in an Excel Map?
  2. K

    Show error message when word in text string isn't in approved list.

    Hello, i would like a code that will show when a user enters a string of text and there isn't a word in that string that doesn't meet the approved list. Approved list: 'World' 'Planet' 'Globe' 'Earth' If someone enters in a cell "Hello World' or 'What is Earth' nothing will show, but if...
  3. D

    Return valuse that contain a string or two strings

    Hi I have a list of book titles in A1:100. In cell C1 the user enters a string of one word (and, if possible, two words separated by a space*) In cells D1 to D5 I need formulas to return the full book titles that contain the word or words the user has entered. *e.g. if "Journey to the...
  4. V

    Find a column by name in row 1 and replace blank cells with the text "Blanks2"...

    Hi, I'd like a macro to find the column named "Earth" in row 1 and replace ALL and ONLY blank cells with the text "Blanks2"... BUT... It should first look at the "Galaxy" column (also in row 1) to find the last row with data in it. Once it knows the last row of data in the "Galaxy" column...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top