+ Reply to Thread
Results 1 to 5 of 5

Remove some characters

  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    MN
    MS-Off Ver
    Excel 2010
    Posts
    8

    Remove some characters

    I have a column that has entries that look like this:


    10, 13.27
    100, 113.13
    140, 13.76
    4, 151.81

    I'm looking for help removing everything from the comma on back. The result of these examples would look like:

    13.27
    113.13
    13.76
    151.81

    Is there a formula to do this?

    Thanks!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Remove some characters

    Try

    =VALUE(RIGHT(A1,LEN(A1)-FIND(",",A1)))

    pasted into B1 and copied down.
    Martin

  3. #3
    Registered User
    Join Date
    09-07-2011
    Location
    MN
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Remove some characters

    Close....

    Here's the first few results:


    10,13.29 13.27
    10,13.57 13.29
    10,14.72 13.57
    10,17.12 14.72
    10,20.51 17.12
    10,32.22 20.51
    10,32.22 32.22

    It works for some, changes the numbers on others.

  4. #4
    Registered User
    Join Date
    12-06-2011
    Location
    Arkansas, USA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Remove some characters

    Looks like you've got cell b2 referencing cell a1 instead of a2. The second value down on the right matches the right-hand number for the top left.

  5. #5
    Registered User
    Join Date
    09-07-2011
    Location
    MN
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Remove some characters

    Oh, duh. Thanks for your help....this works.

+ 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