Problems with * in a criteria range

[Reino Hanninen]

Hi, I have noticed (at least to my mind)very special
problem in using * mark in criteria text. Let me give
example ( in the list below "Tuote" is a field name)

Tuote
Kappa
Laatikko
Liina
Pannu
Lusikka
Kapusta
Paletti

When I write criteria for the DCOUNT function or for
Advanced Filtering to acept from the list all names which
begin with the letter L and eds with the letter a, I use
criteria L*a , but it accepts words "Laatikko", "Liina"
and "Lusikka"! Now my question is -What kind of a
criteria I should use to extract just those words that
begins with "L" and ends with "a".

I would highly appreciate your answer

Regards
Reino

 

[Aladin Akyurek]

Let A1:A8 house the sample you provided, with A1 housing the label.

Leave C1 empty.
In C2 enter:

=AND(LEFT(A2)="L",RIGHT(A2)="a")

In C3 enter:

=DCOUNTA(A1:A8,,C1:C2)

 

[Bob Umlas]

Believe it or not, this will work:
="=L*a"