Well, I thought I understood these text things but this one isn't working. I need to grap part of a UPC code. I want people to enter part of it and a single portal row to appear showing the appropriate product. UPC codes look like this:

7 49623 00157 7

I want people to type '157' which is unique to a product in that exact position (into global text) and that relate to the above calc. How can I say MiddleWords(UPC; 3; 1 (but only the right 3 characters of that 'number of words 1')?? I tried many things to get it and can't. I tried from the left and the right and the middle.

Ok. If I can't figure something out ... sleep on it. Just woke up and immediately put this and it works:

Middle ( UPC; 11; 3 )

Geez. Well, if there is something better I'd like to learn it too but this works. Don't know why I was so focused on counting the words instead of the characters. I spent (wasted) three hours yesterday on this silly thing.