Slicing of contents in a cell [closed]

asked 2013-07-16 16:59:15 +0100

Vineet gravatar image

Consider a cell with contents "abcdefghijklm".
How do I 'slice' this to get contents 'starting from 4th place to 8th place'?
In this case, it will be "defgh".
(It is very similar to the python language slicing :-- aString[3:6]
I looked at LEFT and RIGHT functions. But I want to slice it starting and ending at any given position.



edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 23:07:25.693370