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
|