Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Search for zero cells in table (XP)

    I have numeric tables in Word with lots of cells. I would like to search and replace for those cells that contain just a zero and replace the zero with null content without affecting cells that contain values like 6,000. Is that possible?

    Ronny
    Ronny Richardson

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Tallahassee, Florida, USA
    Posts
    901
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for zero cells in table (XP)

    Hi, Ronny! This is perfect for Word's wildcard search/replace feature.
    [list=1]<LI>Select your table (so that you don't mistakenly replace a zero which intentionally occurs in the body of your document)
    <LI>Click on Edit / Replace
    <LI>Click on More to expand your Search/Replace dialog
    <LI>Click to place a checkmark before "Use wildcards"
    <LI>In the find what box, type the following (without the quotes) <0>
    Karen

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for zero cells in table (XP)

    This can be accomplished using Word's Edit-Replace - in the "Find what" box enter the 0 you are looking for and in the "Replace with" box make sure that it is blank. The trick to making sure that it leaves figures like 6,000 alone is to make sure that you put a check in the search options box titled "find whole words only". If you cannot see the search options then just click on the "More" button and that will expand the dialog box to show you the additional options.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for zero cells in table (XP)

    Hi Ronnie:
    If the cells that you wish to change contain ONLY a 0, you can do a Find/Replace:
    1. Press Ctrl+H to bring up the replace box.
    2. Type <big><font color=red><code><0></code></font color=red></big> in the Find box.
    3. Leave Replace box blank.
    4. Press More & check "Use wildcards".
    5. Press Replace All.

    In Word 2000, I know this will delete the zero in 35.0, but not if it says 35.00. So if you don't have numbers after the decimal point ending in zeroes, you won't have any problems.
    Cheers,

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Search for zero cells in table (XP)

    This worked great, thanks. I feel kinds of dumb for not thinking of this myself.

    Ronny
    Ronny Richardson

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for zero cells in table (XP)

    But if you hadn't asked the question I'd never have seen the other replies and learnt a little about using wildcards (having studiously ignored them in the past). That's the great thing about the Lounge - you don't learn less!!

Posting Permissions

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