Function to truncate string

[Xx7]

In cell B7 I have the letters "abcdefghijkl". I would like a function called "truncate" that takes characters off both the left and right sides.

=truncate(B7, # of chars to delete from left, # of chars to delete from right)

So....

=truncate(B7, 2, 4)


would return "cdefgh"

 

[njimack]

Function truncate(c As Range, l As Integer, r As Integer)

truncate = Mid(c.Value, l + 1, Len(c.Value) - l - r)

End Function

Or you could make use of the following existing functions...

Excel Workbook
	A	B	C	D
1	abcdefghijkl	cdefgh	2	4
Sheet2

 

[Xx7]

hmmm.... doesn't seem to work for me on XL2010. I've never used functions before. Any tricks to it? I assume I just throw the code in there like a macro and can use it like the original functions like "sum", "average".


I put:

=truncate(B7, 2,4) and I got an error

 

[Xx7]

got it going. my fault. Thanks!