Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Posts
    99
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Search, avoiding extra data

    Well, I couldn't think of a better title. And, I am sure I read about this earlier but I could not think of a search term that would find it.

    I have a spreadsheet with a column containing a default set of characters. To some of them, using the F2 function, I add additional information. I now want to remove the contents ONLY from the cells containing JUST the default characters. For instance:

    Cell Contents
    A1 abc
    A2 abcdef
    A3 abcghi
    A4 abd

    I would like to search and replace ONLY cells A1 and A4.
    [I have been here for years; I had to get things restarted]

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    John,

    Unless A4 is a mis-type in your example you could have a problem. However, if you do an Exact match search for ab? it will find both abc & abd. If A4 is a mis-type just do an exact match search for abc.

    Note: Example using Excel 2003
    Attached Images Attached Images
    Last edited by RetiredGeek; 2011-10-18 at 13:15.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Star Lounger
    Join Date
    Feb 2008
    Posts
    99
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Double Palm Slap.

    Yes, A4 was a typo.

    And "Match entire cell contents" is something that I have seen time and time again. Brain freeze and Senior Moment combined.

    Thanks for the information.
    [I have been here for years; I had to get things restarted]

  4. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Or you could filter on the default characters and clear the contents of those cells

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Or you could filter on the default characters 'abc' and clear the contents of those cells<br><br>

  6. #6
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Or you could filter on the default characters 'abc' and clear the contents of those cells

Posting Permissions

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