Home 
Search 
Today's Posts 
#1




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 
#2




If a cell contains a text (unspicified text) then return the specified text
rafaeldepp.mrm wrote:
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 Do you mean something like this? =IF(A1="your text here",A1,B1)  This site is currently under retinkerative buildstruction thingmakery. 
#3




If a cell contains a text (unspicified text) then return thespecified text
Hi,
Thank you for responding! My describing above was wrong. I have tried this formula, but my problem here is "your text here" is not standard text, it can be variable, I mean changeable text. The matter is, is there any formula which i can use it for changeable text in this case? Thank you again! 
#4




If a cell contains a text (unspicified text) then return the specified text
Hi,
Am Tue, 19 Jan 2016 00:59:49 0800 (PST) schrieb : My describing above was wrong. I have tried this formula, but my problem here is "your text here" is not standard text, it can be variable, I mean changeable text. The matter is, is there any formula which i can use it for changeable text in this case? try: =IF(ISTEXT(A1),A1,B1) Regards Claus B.  Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional 
#5




If a cell contains a text (unspicified text) then return thespecified text
That is!!!
Thank you very much! 
#6




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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t  Excel Worksheet Functions  
Enter text in a cell to return a text value in same cell  Excel Discussion (Misc queries)  
select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc...  Excel Programming  
lookup a text cell and return text  Excel Discussion (Misc queries)  
extracting text from within a cell  'text to [email protected] equivalent of 'text to columns'  Excel Programming 