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.
 
Back
Top