Closed Thread
Results 1 to 11 of 11

Google Sheets: Remove Data in bulk

  1. #1
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Google Sheets: Remove Data in bulk

    Hi all,

    I am looking to clean up a list of URLs/domain names on a spreadsheet

    There are around 750 URLs in the list on my spreadsheet and 250 of them I want to remove.

    I have a list of the ones that I want to remove.

    Instead of deleting 1 at a time is there a way i can delete the list in bulk?

    Any tools, functions, or formulas?
    Attached Files Attached Files
    Last edited by lknights1987; 07-27-2021 at 08:29 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,798

    Re: Remove date in bulk

    Please update your forum profile - the splash screen when you launch Excel will tell you which version you have.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Re: Remove date in bulk

    I can't seem to attach anything. Nothing is uploading as far as i can see
    Last edited by AliGW; 07-27-2021 at 08:05 AM. Reason: PLEASE don't quote unnecessarily!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,798

    Re: Remove date in bulk

    It will if you follow the instructions and remember to hit the submit button - try again, please.

    Which version of Excel are you using?

  5. #5
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Re: Remove date in bulk

    Its google spreadsheet
    Last edited by AliGW; 07-27-2021 at 08:07 AM. Reason: PLEASE don't quote unnecessarily!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,798

    Re: Remove Data in bulk

    OK. So, you need to update your profile - put Google Sheets there, please.

    I will move the thread to the correct section. You should have said this in the opening post.

  7. #7
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Re: Remove Data in bulk

    Ohh silly me haha
    Last edited by AliGW; 07-27-2021 at 08:15 AM. Reason: PLEASE stop quoting unnecessarily!

  8. #8
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Re: Remove date in bulk

    Finally it worked
    Last edited by AliGW; 07-27-2021 at 08:15 AM. Reason: PLEASE don't quote unnecessarily!

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,798

    Re: Google Sheets: Remove Data in bulk

    I'm in Ipswich, too. Please update your Excel version - put Google Sheets there.

    Someone who uses that platform will help.

    Administrative Note:

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

  10. #10
    Registered User
    Join Date
    03-01-2021
    Location
    Ipswich
    MS-Off Ver
    Google Sheets
    Posts
    44

    Re: Google Sheets: Remove Data in bulk

    Oh yes, I noticed that .
    Last edited by AliGW; 07-27-2021 at 08:32 AM. Reason: PLEASE stop quoting unnecessarily!

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,798

    Re: Google Sheets: Remove Data in bulk

    1. I asked you NOT to quote unnecessarily. Please do not ignore requests from moderators.
    2. You still haven't updated your forum profile, as requested.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  2. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  3. Google Sheets Master Sheet that pulls in data from other sheets with the last edit date
    By Badvgood in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 12-19-2020, 12:04 PM
  4. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  5. Google Calendar bulk import tool with recurring events.
    By Hindrik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2016, 09:12 AM
  6. Replies: 1
    Last Post: 01-25-2014, 02:10 PM
  7. Excel - bulk processing disparate spread sheets with common data into 1 table or SS
    By rblackcat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2013, 08:41 PM

Tags for this Thread

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