If formula to show all data before certain point in a cell

[owmyheadimtootall]

I have a list of cells that has information countaining:

Clients Name - Telephone Number

What i need is a formula that will only show all data before the hyphen, is this possible?

 

[Norie]

Why not use Data>Text to columns... with the hyphen as a delimiter?

 

[barry houdini]

with a formula....

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

 

[owmyheadimtootall]

that formula works perfectly.

Thanks!