View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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..