If the cell starts with. or with..
Solved
loeh
-
Raymond PENTIER Posted messages 58545 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58545 Registration date Status Contributeur Last intervention -
Hello,
I would like to know in Excel 2003 the function
IF the cell starts with X or Y or Z, THEN... ELSE nothing
I have the function IF(MID(A1,1,3)="abc",d,"")
but I don't know how to integrate the OR, for example: if the cell starts with abc, def or ghi.
Thank you all!! :-))
Configuration: Windows XP / Internet Explorer 6.0
I would like to know in Excel 2003 the function
IF the cell starts with X or Y or Z, THEN... ELSE nothing
I have the function IF(MID(A1,1,3)="abc",d,"")
but I don't know how to integrate the OR, for example: if the cell starts with abc, def or ghi.
Thank you all!! :-))
Configuration: Windows XP / Internet Explorer 6.0
