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 05:28 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
my proposition in attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Thanks Tom, your suggestion works perfectly. My appreciation !
Shridhar, as you can see from my example...the rows have varying data length. Thanks anyway !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks