CONCATENATE not working
works for me
try
=F2 & "-" & G2
--
Gary
"Bruce A. Julseth" wrote in message
...
I have
F2 G2 H2
Zip Plus4 ZipPlus4
84116 3153 =CONCATENATE(F2,"-",G2)
F2 and G2 are "Formated" to be text.
Why is the H2 value =CONCATENATE(F2,"-",G2) and not 84116-3153?
Thank you..
|