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.