View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default If a cell contains a text (unspicified text) then return the specified text

Hi,

Am Tue, 19 Jan 2016 10:22:20 +0100 schrieb Claus Busch:

=IF(ISTEXT(A1),A1,B1)


e.g. if you have 3 strings to find in A1 you can try:

=IF(COUNT(SEARCH({"Text1";"Text2";"Text3"},A1))0, A1,B1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional