I have a column of cells that are all exactly like the below information. In the column next to it, I want to delete everything after the first phone number. So delete the " - You Have..."
How can I only include the "New Call from JOHN DOE (428) 555-5555"
New Call from JOHN DOE (428) 555-5555 - You Have a New Call From: JOHN DOE (428) 555-5555 Received: Friday, June 19, 2015 at 08:35 PM To