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.

=IF(
	ISERROR(
		FIND(" ",A1)
	),A1,RIGHT(A1,
		LEN(A1)-FIND("~",
			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.