software

Hi,
How could I check if the cell in a column starts with a certain alphabet, if
yes, then in a different columns cell add the word quot;DONEquot;
eg: validate column P, if a cell starts with XYZ, then in coulmn B, of the
same row, add the word quot;DONEquot;

Try this:

B1: =IF(LEFT(P1,3)=quot;XYZquot;,quot;DONEquot;,quot;quot;)
OR
B1: =IF(COUNTIF(P1,quot;XYZ*quot;),quot;DONEquot;,quot;quot;)

Copy either of those formulas down

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Proquot;dotquot; wrote:

gt; Hi,
gt; How could I check if the cell in a column starts with a certain alphabet, if
gt; yes, then in a different columns cell add the word quot;DONEquot;
gt; eg: validate column P, if a cell starts with XYZ, then in coulmn B, of the
gt; same row, add the word quot;DONEquot;

Enter this is B2:

=IF(LEFT(P2,3)=quot;XYZquot;,quot;DONEquot;,quot;quot;)

This leaves B2 blank if P2 does not start with XYZ. Copy the formula
down as necessary.

Hope this helps.

Pete