+ Reply to Thread
Results 1 to 3 of 3

Excel Substitution Problem

  1. #1
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2007
    Posts
    107

    Excel Substitution Problem

    Hi,
    I have very common problem of Substitution. I have attached an excel file where column A and Column B contains text strings. Both of these text strings to be removed from the Tex present in column C. And the output should be in column D. I have tried substitute function but that is not working for unknown reason.

    excel forum Snapshot.PNG

    Please help me on this issue.

    Thanks and regards,
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,963

    Re: Excel Substitution Problem

    First, try to use TRIM(original text) to delete extra space, then

    Try using search function to test, and found out some typos in column A/B:

    Column B: "Orignally" => should be "Originally"
    A4: "including his childhood friend Pat Martino , " => should be "including his childhood friend Pat Martino, " (delete 1 space after "Martino"
    similar checking process to A12

    After fixing, try substitute:

    =SUBSTITUTE(TRIM(C2),A2,"")

    Attachment is my testing with SEARCH function first, to help you know how to do if SUBSTITUTE fails.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2007
    Posts
    107

    Re: Excel Substitution Problem

    Hi, the formula works but it doesn't remove the Orginally posted by line as I have shown in the screenshot below. Please let me know about your thoughts.
    Attachment 709352

+ 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. Question - Substitution function is substitution its own values
    By debrad1207 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2018, 10:23 AM
  2. [SOLVED] help / advice with variable substitution in excel header
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2014, 01:54 AM
  3. [SOLVED] SUBSTITUTION Problem!
    By niceguy21 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 01:28 PM
  4. SUBSTITUTION Formula problem
    By dompoma in forum Excel General
    Replies: 2
    Last Post: 06-12-2012, 12:35 AM
  5. [SOLVED] Cell Substitution Problem...
    By AndyAlliance in forum Excel General
    Replies: 3
    Last Post: 04-13-2012, 11:55 AM
  6. If then substitution
    By knitterkuba in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-13-2010, 05:24 AM
  7. [SOLVED] substitution
    By Cossloffe in forum Excel General
    Replies: 1
    Last Post: 06-04-2006, 02:10 AM

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