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

**bitswit** · 02-08-2012, 05:59 AM

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 !!

**Shridhar PS** · 02-08-2012, 06:15 AM

Hi

if you want the same length (output interms of digit) you can use =left(cell reference,number of digits) this will work surely

Regards'
Shridhar

**tom1977** · 02-08-2012, 06:16 AM

my proposition in attachment

**bitswit** · 02-08-2012, 06:26 AM

Thanks Tom, your suggestion works perfectly. My appreciation !
Shridhar, as you can see from my example...the rows have varying data length. Thanks anyway !!