Auto populate text into a cell

[SirHart]

Hello,

I've been pulling my hair out trying to figure out how to make this work and I would certainly appreciate the help. In Excel 2003, I want Excel to automatically place the words "posting date" into a cell everytime the string "xx" is placed in a different cell.

As an example: If cell A13 contains "xx" (no quotations) anywhere in it, I want cell B1 to automatically populate the words "posting date" (no quotations). Is there anyway to do this without doing VBA?

Any help would be perfect!

 

[dfenton21]

Hi There,

This formula will do what you describe:

=IF(ISERROR(FIND("xx",A13,1)), "", "posting date")

Please let me know if you have any further queries.

 

[SirHart]

Right now I'm at home and that formula doesn't work in 2007 excel but I will try it in 2003 tomorrow and let you know how it goes.

 

[SirHart]

dFenton21, that did not work...is there any other solution I can try? I certainly appreciate the effort! I'm clueless on how to do this

 

[SirHart]

=OR(ISNUMBER(SEARCH("xx",(AZ$8))))

This is my current formula. It works for formatting cell color or text, but how do I use it to insert a text string that says "Posting Date" instead?

 

[Jonmo1]

dfenton's formula works for me in 2003

Excel Workbook
	A	B
1	Here is some random text
2	Here is some random text
3	Here is some random text
4	Here is soxxme random text	posting date
5	Here is some random text
6	Here is some random text
7	Here is some random text
8	Here is some random xx text	posting date
9	Here is some random text
10	Here is some random text
Sheet1

 

[Jonmo1]

The problem you may have is that Find is Case Sensitive...
It will find xx but not XX or xX or Xx

Just change Find to Search if that is your issue.

 

[SirHart]

case sensitive or not it doesn't appear to be working on Excel for me. Is there anything I am doing wrong here?

 

[Jonmo1]

Put the formula directly in B1, NOT in conditional formatting.

 

[SirHart]

Well that did the trick! Thanks so much Fenton and Jonmo!