Perfect, thanks for all your help !!!
Perfect, thanks for all your help !!!
Or simply
PHP Code:
=MID(A1;FIND(":";A1)-15;25)
I don't know if you tried snb's formula but if you found that it does not work it is because you need to change the semicolon ( to a comma(,).
You might also take his counting with a grain of salt. 15 Should be 14 and 25 should be 23.
No offence snb. I know you want people to think for themselves.
@jolivanes, have you tested with:
Tausif.Shaikh Aug 8, 2016, 11:12:50 PM
or
Tausif.Shaikh Aug 18, 2016, 3:12:50 PM
Indeed. I stand corrected.
I guess instead we could use Trim
My apologies snb.
@joli
I don't accept, because you shouldn't have apologized in the first place. I always appreciate your contributions very much.
ok, thanks for the kind words and we'll leave it at that.
Keep on "duimen voor Max Verstappen"
Now I don't anymore....
You remember the agreement of Paris to reduce....
Last edited by snb; 09-04-2016 at 04:25 PM.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
@Admin
Kimi is doing better in Singapore.
Could not fing anything for him though.
Bookmarks