Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    6

    Unanswered: Duplicate values to delete in seperate columns

    I have a spreadsheet and I am try to remove part of the text that is similar in another column for example:

    Column A Column B
    654321 marbles and other stuff number 654321 to go

    So I want to delete just the 654321 in column B is there a formula to do that?
    Keep in mind that the numbers change for each row.
    Thanks for your help!

  2. #2
    Join Date
    May 2012
    Posts
    10
    Code:
    C1: =IF(SEARCH(" ",B1,1)<>0,RIGHT(B1,LEN(B1) - SEARCH(" ",B1)),)
    This assumes that a space always follows the number.

    The copy over and paste values.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •