+ Reply to Thread
Results 1 to 2 of 2

Remove string if found in column

  1. #1
    Registered User
    Join Date
    03-28-2012
    Location
    Canada
    MS-Off Ver
    Excel 2011
    Posts
    11

    Remove string if found in column

    Hello,

    I am looking for a little help to string from one column if the string is found in another column. For instance. I know I could trim based on the number of characters but the issue I am having is that they are not consistent.

    A B C(result)

    573 573CH CH

    Screen Shot 2020-06-18 at 11.03.27 AM.png

    Thank you in advance!
    Attached Files Attached Files
    Last edited by dcaplan; 06-18-2020 at 11:07 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Remove string if found in column

    Please try at C2
    =SUBSTITUTE(B2,A2,)

    or
    =MID(B2,LEN(A2)+1,9)

+ 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] Remove Part of a String - From Column B Found in Column A
    By sl729 in forum Excel General
    Replies: 3
    Last Post: 05-20-2016, 11:38 AM
  2. Remove rows when a column is found to contain multiple criteria
    By cmorten82 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-08-2016, 05:59 PM
  3. remove duplicates based on name found in column b
    By antiKILLER in forum Excel General
    Replies: 2
    Last Post: 03-01-2016, 02:57 PM
  4. Replies: 1
    Last Post: 11-14-2014, 07:45 PM
  5. [SOLVED] Remove row if found string for whole spreadsheet
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2014, 02:10 PM
  6. [SOLVED] Remove all rows after Value is found in column
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-03-2011, 04:28 PM
  7. Replies: 4
    Last Post: 10-03-2005, 12:05 PM

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