Hi
if you can hardcode the starting position and ending position have a look at
the MID and the RIGHT function

"ken" wrote:

I've tried =left(a1,6) in B1 the answer is "one two". What I want is only
word "two" for B1 and "six" for B2.

Look forward for the exact answer.
Thanks


"Frank Kabel" wrote in message
...
Hi Ken#
you may explain the underlying logic of this. why do you want in B1 the
second number and in B2 the third one?

"ken" wrote:

A B
one two three =
four five six =

How to filter text so that in cells B1 = two and cell B2 = six

Thanks in advance.