On Thu, 6 Sep 2007 06:16:02 -0700, zzxxcc
wrote:

I'm sorry, Ron. This returns #N/A where it should return: FCM. However, I
think you are on to something.

--

It will return #N/A if:

1. Did you enter the string segments into a NAME'd range? One thing I left
out is that the range must be vertical. If the range is horizontal, then the
formula needs a slight modification.

2. Do you see the {...} around the formula put there by Excel? If not, you
did not enter the formula properly as instructed:

When you ENTER this formula, you must hold down <ctrl<shift while hitting
<enter as this is an ARRAY formula. Excel will place braces {...} around the
formula.

3. The strings in TextStrings are not present in your data.

What do you see?
--ron