CONCATENATE not working
 

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..

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..

CONCATENATE not working
 

Hi Bruce
Probably beacause your cell in H2 is formated as text too.

HTH
Cordially
Pascal

"Bruce A. Julseth" a écrit dans le message
de news: ...
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..

CONCATENATE not working
 

this works
=F2&" - "&G2

"Bruce A. Julseth" wrote:

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..

CONCATENATE not working
 

Should work if text or number

--
Don Guillett
SalesAid Software

"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..

CONCATENATE not working
 

Do a find and replace.

Find =
Replace with =

that will sort it.

"Bruce A. Julseth" wrote:

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..

CONCATENATE not working
 

"PaulW" wrote in message
...
Do a find and replace.

Find =
Replace with =

that will sort it.

"Bruce A. Julseth" wrote:

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..




This worked, namely Find = and replace with =.
Why?

I reFormated H2 to be "General" and it now works.
Why?

Thank you....