Remove Phone Number From String

[cjamps]

Is there a formula I can use to remove a telephone number from a string? I have a column of (999) 999-9999 - WIRELESS CALLER. But sometimes instead of wireless caller it says the person's name. (999) 999-9999 - DOE, JANE. I only want the phone number. I tried the Len command but because the right length wasn't always the same, sometimes the phone number got truncated.

Please advise.
Thanx

[avk]

I suggest kindly split the text & number from cell.
Suppose your data in "A2"
In "B2"

Please Login or Register  to view this content.

In "C2"

Please Login or Register  to view this content.

[Rick Rothstein]

Do your telephone numbers all have the same format (area code in parentheses, space, three digits, dash, four more digits) which is then followed by a space,dash,space? If so, this should work...

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

[cjamps]

Do your telephone numbers all have the same format (area code in parentheses, space, three digits, dash, four more digits) which is then followed by a space,dash,space? If so, this should work...

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

Thanx tons!
This was perfect!