Thread: If a cell contains a text (unspicified text) then return thespecified text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] rafaeldepp.mrm@gmail.com is offline
external usenet poster
  
Posts: 3
Default If a cell contains a text (unspicified text) then return thespecified text
Please help me the following:

A1= ABSDH (for ex.)
B1= STANDARD
C1= (if......) formula

If I have a specified text in A1 for example (absgdjj) then return back to C1 the specified text otherwise give me what contained in B1

Best regards
Rafael
Reply With QuoteReply With Quote