CONCATENATE not working

[Bruce A. Julseth]

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

 

[Gary Keramidas]

works for me

try
=F2 & "-" & G2

 

[papou]

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

HTH
Cordially
Pascal

 

[Guest]

this works
=F2&" - "&G2

 

[Don Guillett]

Should work if text or number

 

[Guest]

Do a find and replace.

Find =
Replace with =

that will sort it.

 

[Bruce A. Julseth]

Do a find and replace.

Find =
Replace with =

that will sort it.

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

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

Thank you....

 

[Dave Peterson]

Saved from a previous post.

Excel likes to help.

Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing
the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I
hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.