How can I test only part of the text in a cell and if true return value of a different cell
E East London Jan 26, 2005 #1 How can I test only part of the text in a cell and if true return value of a different cell
B Bob Phillips Jan 26, 2005 #2 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)
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)
