Recognize Text within Excel

  • Thread starter Thread starter SLD
  • Start date Start date
S

SLD

How do I recognize text in one cell and use that to drive
whether or not and entry is made in the cell next to it?

Example: If cell A1=any text, then A2=yes
 
In A2 enter:

=IF(ISTEXT(A1),"Yes","No")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How do I recognize text in one cell and use that to drive
whether or not and entry is made in the cell next to it?

Example: If cell A1=any text, then A2=yes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text From Cells 3
Importing text with text qualifier 2
Finding Text within an Array 2
Text and Value in Cell 3
Forumla to recognize text 2
if, then display next cell 4
Conditional Format based on sub-string 3
Questions on using conditional formatting 2

Back
Top