Hi,

At work we have to continiously delete a variable in column B:

For example:

We have to edit "Orange - Nokia - 6280" to become "Orange - Nokia"

and

"Vodafone - Motorola - V3" to become "Vodafone - Motorola".

In other words, deleting the phone model number after the phone manufacturer.

Is there a forumla that will do the following:

If Column B contains "Orange/Vodafone - Nokia/Motorola - (mobile model number)" delete the model number or variable after the phone manufacturer

Thanks for reading and I hope i make sense.