Formula for taking out words in cell required

Hi,

Can anyone hlep with this. I have a list of cells some of which just have a name and some have a name then a hyphen and some letters and numbers.

Basically I need a formula that will allow me to take out whatever is typed after the hyphen and if possible to replace it with another letter.

ie, on sheet just now I have info like this in the column:
abc
abcfd - df1
abcb - df2
abcs

And I need this displayed as:
abc / TM
abcfc / TM
abcb / TM
abcs / TM

The amount of letters in the list changes but the letters I want to replace the hyphen and details with will always be the same ie TM. Even if I need to do this over two columns, to remove the hyphen and details then somehow ad on the forward slash TM after whatever is written there.

Hope this makes sense.

If the data is always as in your example, so there is always a space after the intital text string, or is it blank the following should work if the data is in A1

=IF(ISERROR(SEARCH(" ",A1)),A1,LEFT(A1,SEARCH(" ",A1)-1))&" / TM"

However if other combinations such as abc-df2 occur it will fail, but as you have not given them in your example, hopefully this is not the case

Regards

Dav

The data is sometimes words with spaces in the before the hyphen, however, I just replaced the space in your formula with a hyphen and it gives me the full string of words i require followed by / TM.

Thanks a lot, saves me lots of time!