star

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Star Wars: Squardons 0
Symbols & font 8
using if function..please help 2
Maintaining Text Formatting in a Lookup 2
Formulas reversed 2
Star Wars Battlefront VR Mission 19
Greater Than Symbols and calculations 0
Star Wars Battlefront II (Do not buy this game) 44

Back
Top