One way:

=TRIM(MID(LEFT(A1, FIND("$", SUBSTITUTE(A1, "_", "$", 2))),
FIND("_", A1), 32767))

where _ represents a space character to prevent unfortunate linewrap.

In article ,
"zomex" wrote:

eg. "mick jagger bush" "muhammad ali clay" "ayesha bin batool"
suppose that these r the names and i want formula that would be generic to
all, such that it gets "jagger" "ali" and "bin"