Hi, team...
How can I find these simple names within the full names and return the result?
In Sheet1 I have this in A.
<tbody>
<tbody>
DisplayName
Ross Eustace Geller
Rachel Green
Joey Francis Tribbiani Jr.
Monica E Geller
Chandler Muriel Bing Bing
Phoebe Buffay
</tbody>...