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