Zoho Sheet

This spreadsheet removes all strings that do not match a specified pattern. In this example, the pattern is 'X*'.			This spreadsheet was generated by Jocelyn Paine, using Excelsior. There's an explanation of how it works at http://www.j-paine.org/excelsior/repository/remove_non_matches/index.html .

elements to search	the index	matching elements
Not X	-1
X	-1
Not X	-1
Not X	-1
X2	-1
Not X	-1
Not X	-1
Not X	-1
	-1
X4	-1
X5	-1
Not X	-1
Not X	-1

Sheet1