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!
Bookmarks