Choosing the best set of keywords?

How can I classify a set of keywords by location?

• I have a large corpus of keywords and would like to extract the location from them for classification purposes. The list of locations is also available. Is there an easy way to systematically extract locations from these keywords?

• Answer:

  if you have the list of locations you are searching for, then following Excel VBA code can help. Option Explicit Sub Findincell() Dim c As Range, i As Long Dim s As Variant Dim x s = Application.InputBox(Prompt:= _         "Please Select a Range For Search Terms", _         Title:="InputBox Method", Type:=8)         For Each c In Application.InputBox(Prompt:= _         "Please Select a Range to Find In", _         Title:="InputBox Method", Type:=8)   'For i = LBound(s) To UBound(s)   For Each x In s     If InStr(UCase(c), UCase(x)) > 0 Then       c.Offset(, 1) = UCase(x)       Exit For     End If   Next x   If c.Offset(, 1) = "" Then c.Offset(, 1) = "OTHER" Next c End Sub refer following page for step by step guide to run this VBA Code in Excel. http://faddies.info/blog/how-to-use-macros/