find text, display text

[Guest]

I want to find text within a cell and, if found, display a text message of my
choosing. For instance, if A1 has the txt "Special Price", then I want B1 to
say, "Special." If it says "Regular Price", I want B1 to say "Reg."
Thanks!

 

[Frank Kabel]

Hi
you may have a look at VLOOKUP (together with a lookup table). See:
http://www.contextures.com/xlFunctions02.html

 

[Max]

One way

Put in B1:

=IF(TRIM(A1)="Special Price","Special",IF(TRIM(A1)="Regular
Price","Reg",A1))

Above assumes that A1 contains neither Special Price"
nor "Regular Price", the value in A1 is to be returned

 

[Max]

Above assumes that A1 contains neither Special Price"

nor "Regular Price", the value in A1 is to be returned

Oops, typo (missing "if") in above lines, should read as: