If function?

[Paul]

Newbie question...I'm looking for the formula that will report the value that
I want in column B. I guess wildcards must nbe used. I tried =IF (A1 =
"*Catalog*", "Catalog", IF(A1 = "*Stock*", "Stock"))

A B
Stock - Rock Stock
Catalog - Indie Catalog
Catalog - Rock Catalog
Stock - Indie Stock

Thanks for your help.

Paul

[Chip Pearson]

Try

=IF(COUNTIF(A1,"*stock*"),"stock","no stock")


"Paul" <[email protected]> wrote in message
news:[email protected]...
> Newbie question...I'm looking for the formula that will report
> the value that
> I want in column B. I guess wildcards must nbe used. I tried
> =IF (A1 =
> "*Catalog*", "Catalog", IF(A1 = "*Stock*", "Stock"))
>
> A B
> Stock - Rock Stock
> Catalog - Indie Catalog
> Catalog - Rock Catalog
> Stock - Indie Stock
>
> Thanks for your help.
>
> Paul
>

[Tom Ogilvy]

=if(countif(A1,"*Catalog*"),"Catalog",if(countif(A1,"*Stock*"),"Stock","not
found"))

--
Regards,
Tom Ogilvy


"Paul" <[email protected]> wrote in message
news:[email protected]...
> Newbie question...I'm looking for the formula that will report the value
that
> I want in column B. I guess wildcards must nbe used. I tried =IF (A1 =
> "*Catalog*", "Catalog", IF(A1 = "*Stock*", "Stock"))
>
> A B
> Stock - Rock Stock
> Catalog - Indie Catalog
> Catalog - Rock Catalog
> Stock - Indie Stock
>
> Thanks for your help.
>
> Paul
>

[Paul]

Thanks chips, but what happens with my other variable?

"Chip Pearson" wrote:

> Try
>
> =IF(COUNTIF(A1,"*stock*"),"stock","no stock")
>
>
> "Paul" <[email protected]> wrote in message
> news:[email protected]...
> > Newbie question...I'm looking for the formula that will report
> > the value that
> > I want in column B. I guess wildcards must nbe used. I tried
> > =IF (A1 =
> > "*Catalog*", "Catalog", IF(A1 = "*Stock*", "Stock"))
> >
> > A B
> > Stock - Rock Stock
> > Catalog - Indie Catalog
> > Catalog - Rock Catalog
> > Stock - Indie Stock
> >
> > Thanks for your help.
> >
> > Paul
> >
>
>
>

[Rajah]

If you want to extract the leftmost part, before the dash, you might
try these two functions.

in B1:
=SEARCH(" - ", A1)

That puts a 6 in B1, which is the position of the dash.

in C1:
=LEFT(A1, B1)

That puts "Stock" in C1, which is the leftmost portion of A1 until the
dash.

(When you're happy with the first line, you should copy these to the
second and subsequent lines with the Fill Down command.)

You may also combine these into one nested function:
=LEFT(A1, SEARCH(" - ", A1))

The way you can find these nifty functions is clicking on the "fx"
probably above the "B" column header. You can enter a description of
what you're looking for or just pick the Text category.

[Bob Phillips]

=IF(COUNTIF(A1,"*stock*"),"stock",IF("COUNTIF(A1,"*catalog*"),"Catalog","Nei
ther"))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Paul" <[email protected]> wrote in message
news:[email protected]...
> Thanks chips, but what happens with my other variable?
>
> "Chip Pearson" wrote:
>
> > Try
> >
> > =IF(COUNTIF(A1,"*stock*"),"stock","no stock")
> >
> >
> > "Paul" <[email protected]> wrote in message
> > news:[email protected]...
> > > Newbie question...I'm looking for the formula that will report
> > > the value that
> > > I want in column B. I guess wildcards must nbe used. I tried
> > > =IF (A1 =
> > > "*Catalog*", "Catalog", IF(A1 = "*Stock*", "Stock"))
> > >
> > > A B
> > > Stock - Rock Stock
> > > Catalog - Indie Catalog
> > > Catalog - Rock Catalog
> > > Stock - Indie Stock
> > >
> > > Thanks for your help.
> > >
> > > Paul
> > >
> >
> >
> >