star

does a star(*) within a cell have any other meaning apart from a symbol for
multiplication within a formula???

If it's included in text, it can represent a wild card:

=countif(a1:a10,"*shashi*")

will count all the cells in A1:A10 that contain Shashi somewhere in that cell.



shashi wrote:
>
> does a star(*) within a cell have any other meaning apart from a symbol for
> multiplication within a formula???

--

Dave Peterson

shashi wrote:

>does a star(*) within a cell have any other meaning apart from a symbol for
>multiplication within a formula???
>
>

Excel will tell you about various uses if you ask it. Click on Help >
ContentsAndIndex > Find and type in your star or asterisk and it comes
up with several variations.

Bill