Lenny

Posts: n/a

How do I use a wildcard in an if statement?

I want to use a conditional statement to see if a particular cell has a
specific text within a cell. For example:
I want to know if cell A1 contains the text "bag" even though it actually
contains "Large BAG 3".

I want this to work but it does not:
if(A1="*bag*","yes","no")
It should return "yes" since bag is within the cell.
Please help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wildcard Not Working in IF statement	[email protected]	Excel Worksheet Functions	6	January 9th 05 07:49 AM
7+ nested if statement?	Turi	Excel Worksheet Functions	3	December 20th 04 07:55 PM
Statement	lintan	Excel Worksheet Functions	1	December 2nd 04 11:31 PM
Duplicate fields does not match up! If statement	Patsy	Excel Worksheet Functions	0	November 11th 04 12:16 AM
IF Statement difficulty	susan hayes	Excel Worksheet Functions	3	November 2nd 04 09:46 PM

All times are GMT +1. The time now is 01:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us