Thread: Create a conditional formula to replace
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Create a conditional formula to replace
Enter this is B2:

=IF(LEFT(P2,3)="XYZ","DONE","")

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

Hope this helps.

Pete

Reply With QuoteReply With Quote