+ Reply to Thread
Results 1 to 2 of 2

Help to Subtract Text

Hybrid View

  1. #1
    Registered User
    Join Date
    05-01-2021
    Location
    Guwahati, Assam
    MS-Off Ver
    Google Sheet
    Posts
    2

    Exclamation Help to Subtract Text

    Hi,

    I've got the access to a pretty big file where there I need to subtract text. Please review the attached file.
    Example: In cell A2 there is a text "PrestigeAssam" and in cell B2 there is text "Assam". So now I want in C2 there is this text "Prestige" through automation.

    Screenshot 2021-05-01 at 1.32.36 PM.png
    Sorry unable to upload worksheet so uploading a screenshot. Please help.
    Last edited by Wraith2102; 05-01-2021 at 04:04 AM.

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

    Re: Help to Subtract Text

    Try:
    Formula: copy to clipboard
    =SUBSTITUTE(A2, B2, "")
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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


+ 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] Subtract % from Text
    By cartica in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 04-19-2020, 12:30 PM
  2. Cell calculation - Text query ( Add / Subtract depending on text )
    By Glorioso999 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-14-2016, 10:33 AM
  3. [SOLVED] Subtract certain text
    By Rennurg in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-01-2015, 08:34 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