| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
star
does a star(*) within a cell have any other meaning apart from a symbol for
multiplication within a formula??? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what does the star (*) indicate in an excel spreadsheet | Excel Discussion (Misc queries) | |||
| Excel code conversion | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Linear Mode
