Remove everything after 2nd space

[MIKIEMILLER]

I feel this is an easy question, but cannot seem to figure out the answer.  How would you get rid of all the characters after the second space?

[Field Name]

JP Smith (Micheals) Market

T Warner Market

A Phillips (Hounds) Farms

Kelley Williams Tower

So it would look like this

[Field Name]

JP Smith

T Warner

A Phillips

Kelley Williams

Thanks

[andrey_krylov · Accepted solution]

Hi Matt. Try this

Left([Field Name], Index([Field Name], ' ', 2))

[Jesh19]

Try this.

If you want at the script level, try the below expression.

=Left('FieldName',Index('FieldName',' ',2))