+ Reply to Thread
Results 1 to 6 of 6

Trying to remove two text strings with one formula - possible nesting issue

  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    New York
    MS-Off Ver
    Microsoft 365 Version 2101
    Posts
    4

    Exclamation Trying to remove two text strings with one formula - possible nesting issue

    Hope someone has some ideas, we're trying to search and substitute two text strings.

    Currently, it works when attempting to remove one string, but when nesting the formula for the second string it fails. Ideally, the formula should find "CoLoad" and "Not CoLoad" then remove both before entering the data in the next column.

    Capture.PNG

    We've tried the below formula, but it only works for the second instance it's seeking, in this case "Not CoLoad"

    =IF(IFERROR(SEARCH("Coload",DestinationLocation),-1)>-1,REPLACE(DestinationLocation,SEARCH("NotCoload",DestinationLocation),9,""),DestinationLocation)

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,811

    Re: Trying to remove two text strings with one formula - possible nesting issue

    Maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-23-2021
    Location
    New York
    MS-Off Ver
    Microsoft 365 Version 2101
    Posts
    4

    Re: Trying to remove two text strings with one formula - possible nesting issue

    Thanks TMS, but it's still only removing one, the "Not CoLoad"
    MicrosoftTeams-image.png

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,811

    Re: Trying to remove two text strings with one formula - possible nesting issue

    Looks like it's case sensitive.

  5. #5
    Registered User
    Join Date
    02-23-2021
    Location
    New York
    MS-Off Ver
    Microsoft 365 Version 2101
    Posts
    4

    Re: Trying to remove two text strings with one formula - possible nesting issue

    That was it, thanks so much!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,811

    Re: Trying to remove two text strings with one formula - possible nesting issue

    You're welcome. Thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Get strings between two strings in text file and remove the rest
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-15-2018, 10:18 AM
  2. Replies: 13
    Last Post: 07-08-2012, 11:26 PM
  3. Nesting Formula Issue???
    By plitv001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2007, 08:26 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