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

N

noswad

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 phon
manufacturer.

Is there a forumla that will do the following:

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

Thanks for reading and I hope i make sense
 
B

Biff

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
 
C

CLR

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
 
Top