Results 1 to 4 of 4

How to remove all data to the right of last instance of a seperator

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2009
    Location
    New Delhi
    MS-Off Ver
    Excel 2007
    Posts
    41

    How to remove all data to the right of last instance of a seperator

    Hello all,
    Was wondering if any kind soul can solve my problem :

    I have thousands of rows of data like this :
    111,222222,333333,444
    66666,555555,999,88888

    Each row contains multiple instances of a seperator. All I want is a formula that will remove all data to the RIGHT of the last seperator
    So now the above rows become :
    111,222222,333333,444 becomes 111,222222,333333
    66666,555555,999,88888 becomes 66666,555555,999

    Thanks in advance for your help !!
    Last edited by bitswit; 02-08-2012 at 06:28 AM.

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