How can I remove the email address and the phone number from the D columns using formula ?

I tried `=LEFT(D2,FIND("@",D2))` but it doesn't fully remove the email address.

I tried to match the columns to left to remove but that didn't work.

```
=LEFT(D2,LEN(B2))

=TRIM(MID(D2,LEN(B2)+2,1000))

```

[![enter image description here](https://i.stack.imgur.com/ZGWfa.png)](https://i.stack.imgur.com/ZGWfa.png)