How do I test a cell for part of text
 

How can I test only part of the text in a cell and if true return value of a
different cell

Use the LEFT, MID or RIGHT functions.

Eg A = ABCDEF

=IF(LEFT(A1,2)="AB",

=IF(MID(A1,2,2)="BC",

iF(RIGHT(A1,3)="DEF",

--

HTH

RP
(remove nothere from the email address if mailing direct)


"East London" <East wrote in message
...
How can I test only part of the text in a cell and if true return value of
a
different cell