IF Column A contains "xyz" replace with...

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.

Hi!

Use Edit>Replace

Select the range of cells in question
Goto Edit>Replace
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" <noswad.2bvhq5_1154455212.5036@excelforum-nospam.com> wrote in
message news:noswad.2bvhq5_1154455212.5036@excelforum-nospam.com...
>
> 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
>
>