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.


--
noswad
------------------------------------------------------------------------
noswad's Profile: http://www.excelforum.com/member.php...o&userid=36993
View this thread: http://www.excelforum.com/showthread...hreadid=567161