right/left function

[Guest]

I need a formula to cut the first X characters from the left and the last Y characters from the right of a text string. Anyone know how to do this? Thanks in advance.

 

[Steve Hartman]

How do you want the result to look? Will it be two text strings or do you want to concatenate them into one string? Or are these actually text representations of numbers you will want to be formatted as numbers?

 

[Mark W.]

On 2002-03-12 12:42, Anonymous wrote:
I need a formula to cut the first X characters from the left and the last Y characters from the right of a text string. Anyone know how to do this? Thanks in advance.

For a value in cell A1...

=LEFT(RIGHT(A1,LEN(A1)-X),LEN(A1)-X-Y)