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.