Text

R

Robo

I would like a formula that would give a result "Yes" or "No" if a tex
field contained the word Tower, is this possible?
Thank
 
H

hgrove

Jason Morin wrote...
=IF(A1="Tower","Yes","No") ...
-----Original Message-----
Click to expand...

The word 'contained' in the OP is ambiguous. It could also mean

=IF(COUNTIF(A1,"*Tower*"),"Yes","No"
 
J

Jason Morin

It's not ambiguous to me.
-----Original Message-----
Jason Morin wrote... possible?

The word 'contained' in the OP is ambiguous. It could also mean

=IF(COUNTIF(A1,"*Tower*"),"Yes","No")
Click to expand...
 
J

John Woodgate

I read in microsoft.public.excel.worksheet.functions that hgrove
Jason Morin wrote...
..

Does the phrase 'Tower of Ignorance' *contain* the word Tower?
Click to expand...
Does the phrase 'Tower of barges'? (;-)
 

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

Using formula to convert date result to text 3
coding descriptors 5
Macro for search tool with multiple entries 2
Autonumber field in Excel that behaves the same as Access 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Link a text box based on drop down box with four options MS Word 365 0
Replace in a group or selection or collection of word files 1
Relating 2 separate texts in word 1

Top