+ Reply to Thread
Results 1 to 6 of 6

Have 2 columns, how do I delete the contents in one from the other?

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    40

    Have 2 columns, how do I delete the contents in one from the other?

    Hi there, I have 2 columns of data containing numbers and words. How do I delete one column from the other? The data in not of fixed length or position in the cell and can be anything numerical value, word or value / combo.

    For example:
    Column A Column B

    Delete:
    Test from: 1987 Test orange 23.0
    46 from: Blue game 46 one hundred
    Sample from: Sample 33212 onboard
    f27 from: already there f27 forever

    Many thanks
    Last edited by mike_m1; 02-06-2011 at 04:36 PM. Reason: Make it clearer

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,837

    Re: Have 2 columns, how do I delete the contents in one from the other?

    Your description is not clear. Also, as you can see, you lost the column spacing in your sample. You should post a "befor" sample and an "after" sample, giving reasons why something was deleted, and from which column. If you do, please use [ode]tags:

    [code]
    testing testing
    abc def
    g hijk
    [/code]
    then the columns will line up more clearly
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-28-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    40

    Re: Have 2 columns, how do I delete the contents in one from the other?

    Thanks for helping me make it clearer:

    Before Column A
    Please Login or Register  to view this content.
    Column B:
    Please Login or Register  to view this content.
    After the contents from column A have been removed from Column B to give a new column B of:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-28-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    40

    Re: Have 2 columns, how do I delete the contents in one from the other?

    So what I'm after is how do you delete the contents of one column from another containing the same contents and other values?

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,837

    Re: Have 2 columns, how do I delete the contents in one from the other?

    You can use a helper column with the formula:
    Please Login or Register  to view this content.
    Which looks in B to find the string held in A and substitutes NOTHING in its place
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-28-2010
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    40

    Re: Have 2 columns, how do I delete the contents in one from the other?

    Excellent, works brilliantly.

    Many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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