Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Location
    Hillsdale, New Jersey, USA
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding * in formulas (XP/SP2)

    How can one find *2 (meaning times 2) in a formula. * is the wild card, so I get all cells with 2 in them.

    Thanks!!!

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding * in formulas (XP/SP2)

    I'm using Excel 97, but my Find dialog box includes a check box labeled "Find entire cells only". Check that box and see if you can get what you need.

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Location
    Hillsdale, New Jersey, USA
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding * in formulas (XP/SP2)

    I figured it out. All you have to do is put =*2 in the find box. But that brings up another problem: How do you find cells containing any multiplier (ones that have =*anynumber).

    ??

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Finding * in formulas (XP/SP2)

    Search for

    <big>~*</big>

    that is a tilde followed by the asterisk.

    You can use the same approach to find a ? (~?) or indeeed a tilde (~~)

    Andrew C

  5. #5
    Star Lounger
    Join Date
    Feb 2003
    Location
    Hillsdale, New Jersey, USA
    Posts
    72
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding * in formulas (XP/SP2)

    That's it!

    Thanks!!!!

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •