How to remove two specific words from each cell in a column

Dear All,
I have a column with almost 1000 rows and in each cell there is a company name followed by: - price high
So, for example, it could be INDO TECH TRANSFORMERS - PRICE HIGH
or INDO GULF DEAD - 04/03/03 - PRICE HIGH

I just need to remove - Price High and leave the rest same. If for some reason, there is no price high in that cell, I dont want to change anything in that case.
Most of the formulas I have come across to solve a problem like this focus on removing last two words or characters, but I only want to remove these particular words which though in most cases are the last two words only.

Thanks a lot in advance you wonderful people!

If A1="INDO TECH TRANSFORMERS - PRICE HIGH"

Then in B1 use this formula... =IF(RIGHT(A1,10)="PRICE HIGH",LEFT(A1,LEN(A1)-13),A1)

Might try Find and Replace.

=substitute(a1,"- price high","")

Thanks so much. They all work fine. Unfortunately the reason for which i wanted to do this is not working now. Ok, let me explain. There are two columns with 1000+ company names in each column. In the first column, company names are followed by price high as I explained above. In the second column, most of the company names are same as first column except that they dont have price high after the name. That's why I wanted to remove price high and then match the two columns to spot some unique company names in both columns. After I removed price high, I did a conditional formatting and tried to highlight the duplicate values. I was convinced that since the company names are now same, it should be fine. But somehow its not doing that-even though the names are exact in both columns like below.

HIND SYNTEX HIND SYNTEX

HINDITRON TEKTRONIX DEAD - 03/02/99 HINDITRON TEKTRONIX DEAD - 03/02/99

Any thoughts why its not working or perhaps there is any other way to do this?
Thanks so much.

I guess as martin mentioned, there are perhaps spaces in one cell which prevent from seeing both as same. How to get around that? Perhaps deleting all such spaces first? Thanks.

Hi pahari,

If you are using Kevin's or Ghozi's formulas, then you must change "- price high" to " - price high"... they were missing an extra "space" before the dash...

Thanks guys. Djapigo, yes it worked now! Thanks so much!