View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajula Rajula is offline
external usenet poster
 
Posts: 53
Default If statement query

In a column i have some values starting with "TBA, AAA, BBB 123" . If the
string begins with TBA, then i want to return TBA in another cell. else i
want to return the value "Existing". Is there a function i can use to do this?