ChrisMendoza

Thanks for your quick reply

I am not getting a #VALUE error, or any kind of error.

I did "Evaluate Formula" on the one that does NOT calculate/work, and tried to upload the image but it won't let me. The popup says "The cell currently being evaluated contains a constant.

Here is the formula that does NOT work, copied from the cell

=CONCATENATE("[",LEFT(D2,1),LEFT(MID(D2,(FIND(" ",D2,1))+1,256),1),"-",C2,"]"," ",F2) |

OR COPIED from the Formula Bar

=CONCATENATE("[",LEFT(D2,1),LEFT(MID(D2,(FIND(" ",D2,1))+1,256),1),"-",C2,"]"," ",F2)

Here is a Concat formula that IS working.

=CONCATENATE("[",LEFT(D2,1),LEFT(MID(D2,(FIND(" ",D2,1))+1,256),1),"-",C2,"]"," ",F2)

I did Evaluate formula here too and the message reads:

"To show the result of the underlined expression, click Evaluate. The most recent result appears italicized." I clicked Evaluate several times and it cycles through the data desired each time I click Evaluate. First, the underlined expression is the first appearance of "D2" above. The field contains employee name. When I click Evaluate the person's name pops into the formula instead of the first appears of D2. I simulated this below.

=CONCATENATE("[";LEFT("*First Last'*;1);LEFT(MID(D2;(FIND(" ";D2;1))+1;256);1);"-";C2;"]";" ";F2)

This is so weird - can you figure out what's wrong??

Thank you,

Jean G.