Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 18th 16, 01:29 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
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

  #2   Report Post  
Old January 19th 16, 04:39 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2003
Posts: 537
Default 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   Report Post  
Old January 19th 16, 08:59 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 3
Default 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   Report Post  
Old January 19th 16, 09:22 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,866
Default 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   Report Post  
Old January 19th 16, 09:35 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 3
Default If a cell contains a text (unspicified text) then return thespecified text

That is!!!

Thank you very much!


  #6   Report Post  
Old January 19th 16, 09:35 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,866
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2 criteria lookup of text. Return text form column 3. SUMPRODUCT t zzxxcc Excel Worksheet Functions 2 August 26th 08 11:04 PM
Enter text in a cell to return a text value in same cell Danno 24/7[_2_] Excel Discussion (Misc queries) 6 May 9th 08 06:26 AM
select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... jsd219 Excel Programming 0 October 19th 06 05:04 PM
lookup a text cell and return text Cristi R Excel Discussion (Misc queries) 4 August 2nd 06 02:41 PM
extracting text from within a cell - 'text to [email protected] equivalent of 'text to columns' Dan E[_2_] Excel Programming 4 July 30th 03 06:43 PM


All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017