recognizing text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function that will recognize any text in a specified cell and if true, enter a specific numeric value in another cell?
 
Hi Wayne!

Take a look at the ISTEXT function under the Information
classification.

=IF(ISTEXT(A1),7,"")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Is there a function that will recognize any text in a specified cell and if
true, enter a specific numeric value in another cell?
Click to expand...

If the text were in cell A1 and the desired number in B1, then enter the
following formula in B1.

=IF(A1="some text",999,"")

If the text you're searching for could be just a part of the text in A1, use

=IF(COUNTIF(A1,"*some text*),999,"")
 
Hi Wayne!

Pleased to help always. Keep posting and try answering a few.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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

If logical function with text and numbers 7
Conditionally formatting numeric data and text differently 1
#value error for sumproduct using RIGHT cmd 0
Using the If function for text 3
trouble with lookup in a range of cells. 5
recognizing words as numbers...for a formula 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
value not recognized as a formula 1

Back
Top