+ Reply to Thread
Results 1 to 4 of 4

How to delete contents in all cells that display A02

  1. 10-31-2008, 12:11 PM #1
    sandss
    sandss is offline
    Registered User
    Join Date
    10-31-2008
    Location
    Atlanta
    Posts
    2

    How to delete contents in all cells that display A02

    Can anyone advise me on how to delete contents in all cells systematically, that display ZZZ and their all in the same column list.
    Thanks
    Last edited by sandss; 10-31-2008 at 12:18 PM. Reason: Missed word
    Reply With QuoteRegister To Reply
  2. 10-31-2008, 12:14 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Welcome to the forum.

    Find and replace A02 with nothing?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 10-31-2008, 12:20 PM #3
    sandss
    sandss is offline
    Registered User
    Join Date
    10-31-2008
    Location
    Atlanta
    Posts
    2
    How would I do that when there are thousands of them.
    Reply With QuoteRegister To Reply
  4. 10-31-2008, 12:29 PM #4
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Ctrl-H / Find what:ZZZ /Replace with: "nothing" ( blank)
    Replace all
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1