trying to capture everything LEFT of the second space

[C.S.]

Assume my data is in column A. A bunch of names, varying in length. I want to use a LEFT function in column B, but I want it to capture everything left of the second space.

Thanks
clint

 

[barry houdini]

Try

=LEFT(A2,FIND(" ",A2,FIND(" ",A2)+1)-1)

 

[C.S.]

thanks barry! perfect.