Finding a string
Hello
I have a list of peoples names which are prefixed by a
title. The prefixes cannot be separated into another
column.
Is there any way I can Find the whole of the persons name,
without including the prefix.
eg if myname = Susan Brown
can I find it if the cell contains Mrs Susan Brown
Any help much appreciated
|