How to Do a Reverse String Search in Excel Using FIND

The Reverse String Search Formula

The full syntax of the reverse string search formula is complicated and a bit confusing, so we will break down each part individually. First, though, let’s take a look at the full formula for cell A1 in our example.

		FIND(" ",A1)
			SUBSTITUTE(A1," ","~",
				LEN(A1)-LEN(SUBSTITUTE(A1," ",""))

You can select everything above and paste it into a cell to find the last word in the string in cell A1.