+ Reply to Thread
Results 1 to 7 of 7

Remove a row using find and replace?

  1. #1
    Registered User
    Join Date
    09-29-2011
    Location
    somerset
    MS-Off Ver
    Excel not sure what v
    Posts
    4

    Remove a row using find and replace?

    I have a product csv from a fancy dress merchant.

    Basically what i am trying to do is remove all the rows which contain the words, adult, **** etc any words that would suggest the costume is for an adult.

    Im trying to just leave the kids / babies/ teens costumes in the csv.

    I thought the best way to do this would be to identify all the fields with the keywords in the column 'product name' and remove the entire row. but i cant do it using find and replace,

    does anyone know how i can do it?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Remove a row using find and replace?

    Hi,

    One way would be to use Data Autofilter to display "adult*" in the Product Name column and then select and delete all the filtered rows.

    Regards
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-29-2011
    Location
    somerset
    MS-Off Ver
    Excel not sure what v
    Posts
    4

    Re: Remove a row using find and replace?

    thanks i'll give it a go

  4. #4
    Registered User
    Join Date
    09-29-2011
    Location
    somerset
    MS-Off Ver
    Excel not sure what v
    Posts
    4

    Re: Remove a row using find and replace?

    that works great thanks.

    Now I need to remove the blank rows BUT only the blank rows not all the blank cells because the shift up will mess up my data, any ideas on that one?

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Remove a row using find and replace?

    Sort the data and all the blank rows will go at the bottom. So you don't actually have to delete them.

  6. #6
    Registered User
    Join Date
    09-29-2011
    Location
    somerset
    MS-Off Ver
    Excel not sure what v
    Posts
    4

    Re: Remove a row using find and replace?

    excellent thanks!

  7. #7
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Remove a row using find and replace?

    If this was useful then please rate it appropriately.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1