+ Reply to Thread
Results 1 to 2 of 2

Subtract text in one cell from another cell? Trying to split cells...

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    Irving, TX
    MS-Off Ver
    Excel 2010
    Posts
    13

    Unhappy Subtract text in one cell from another cell? Trying to split cells...

    Hi,

    I am sure the answer is right in front of me, but my head hurts.

    I have two columns, one that has a run-on string of text (A) and another where I've extracted text from the left (B), the character length varies though. I have figured out a way to do this - as now the character length should start being consistent, but I need to take the run-on minus what was extracted and have the remaining text show in another cell (C).

    I'm sure this doesn't make sense but here is what I have:
    I have a run-on text string that isn't delimited and doesn't always have the same amount of leading characters, so I can't split by fixed width...

    Column A: raw Text
    Column B: I figured out
    Column C: What I want

    Column A Column B Column C
    1103HYclose 1103 and 1104 task 1103HY close 1103 and 1104 task
    CHGChange Couns code to CHG CHG Change Couns code to CHG
    CMMOMHYchange MOM flag CMMOMHY change MOM flag

    Can anyone please help me??
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Subtract text in one cell from another cell? Trying to split cells...

    In D2, enter =SUBSTITUTE(A2,B2,"",1) and drag the formula down.

+ 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. vlookup and split text data from one cell across different cells
    By carog in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-26-2015, 09:09 AM
  2. [SOLVED] split a string of text in one cell into 2 new cells after occurance of second comma
    By syncguy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-06-2015, 12:50 AM
  3. Excel VBA Split Text in Cell wit vbLF for multple Cells
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2014, 12:43 PM
  4. Subtract a cell from another cell if another cell equals text
    By kokeeffe1981 in forum Excel General
    Replies: 1
    Last Post: 10-22-2012, 09:52 PM
  5. Macro to split the text in the cell to different cells ( as per enclosure )
    By mvel_sky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2012, 01:23 PM
  6. split text in one cell into multiple cells without breaking the wo
    By Prashant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2006, 04:48 AM
  7. [SOLVED] Split Long Text Cell into Two Shorter Cells Without Splitting Word
    By Naomi T in forum Excel General
    Replies: 1
    Last Post: 07-07-2005, 01:49 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