On Tue, 12 Aug 2008 03:41:01 -0700, JusMe
wrote:

evaluating the formula doesn't give errors; it gives the correct string, but
it still gives '3' in each line where months 10, 11 or 12 are referenced ....

I need to get Excel to evaluate all 15 characters and not just the first 14,
or so it seems ....

I would not have expected the formula to give an error. The next step is to
see what Excel is matching on.

A first try at that would be to use Edit/Find and copy paste the exact string
that your formula is generating into the Find What: box, and see if there are
multiple matches.

To copy/paste the exact string, I would

select the box with the concatenate formula that is giving the unexpected
result

Edit/Copy

Edit/Find

select Find What:

<ctrl-V (which should paste the value into the Find What box.

<Find All and a list of matching cells should appear, along with the value
contained in each cell.

If that doesn't work, we'll try a different method.

--ron