star

S

shashi

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

Dave Peterson

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.
 
G

Guest

shashi said:
does a star(*) within a cell have any other meaning apart from a symbol for
multiplication within a formula???
Click to expand...

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
 
Top