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

Hi!

Use EditReplace

Select the range of cells in question
Goto EditReplace
Find what: Orange - Nokia*
Replace with: Orange - Nokia
Relace All

Repeat the process for Vodafone - Motorola
Find what: Vodafone - Motorola*
Replace with: Vodafone - Motorola

If you do this often turn on the macro recorder when you do the above and in
the future just run the macro.

Biff

"noswad" wrote in
message ...

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

If your format is always as presented in your samples, then this formula in a
helper cell should work......

=LEFT(A1,FIND("-",A1,FIND("-",A1,FIND("-",A1,1)+1))-2)

Vaya con Dios,
Chuck, CABGx3




"noswad" wrote:


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