# Take out information in a cell

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
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
It can be done with formula but you can also do it with text to column option using fix width option
0
Group Finance ManagerCommented:
Try
=LEFT(A1,FIND("-",A1))

assuming text is in A1
0
Group Finance ManagerCommented:
This is better

=LEFT(A1,FIND("-",A1)-1)

It removes the -
0
Author Commented:
Hey Roy... it cut off at the first "-" so it looks like this:

New Call from

JAMES DOE (428) 555
0
Group Finance ManagerCommented:
Sorry, try this it should find the second occurrence of "-"

=LEFT(A1,FIND("-",A1,FIND("-",A1)+1)-1)
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Commented:
here is my method

=TRIM(MID(SUBSTITUTE(\$A1,"-",REPT(" ",99)),COLUMN(A1)*99-98,99))&"-"&TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",99)),COLUMN(B1)*99-98,99))
0
Author Commented:
Thanks! I'll be posting a similar question next.
0
Group Finance ManagerCommented: