Hi everyone! Here's the problem:

In cell A3, we have the string G*B+1720."ssx"_2009_03 and I'm trying to pull ssx. The word "Customer" also has to be in front of it.

I typed the formula =CONCATENATE("Customer ",MID(A3,SEARCH(".",A3,1)+2,SEARCH(".",A3,SEARCH(".",A3,1)+2)-SEARCH("_",A3,1)-2)) and it's giving me the #VALUE! error. Can anyone shed some light on what exactly is wrong with that? Thanks!