concatenate not working

[Ralph]

I am trying to combine fields in Excel 2007

=CONCATENATE(AB4,AC4) or
=AB4 & AC4

and when I click enter and move to the next field the field where I left the
formula remains =CONCATENATE(AB4,AC4) and doesn't seem to exicute. I was
able to make a single cell reference bring forward the value. Example =AB4
and enter then the value of AB4 appears in the cell. Frustrated Thursday.

 

[Rick Rothstein]

It sounds like the cell you have your formula in is formatted as Text.
Change its format to General and re-enter the formula.

 

[Ralph]

that was part of the problem but now I see more problems.

I am trying to concatenate an address string and the address1 field can be
blank in which as I want to drop the comma. Here is the formula I have that
doesn't work.

AB4 is the Address1 field

=IF(AB4 ISBLANK,( AC4&", "&AD4&", "&AE4&" "&AF4),(AB4&", "&AC4&", "&AD4&",
"&AE4&" "&AF4))

thanks

 

[Ralph]

I played with it and got this to work:

=IF(AB346 = "",( AC346&", "&AD346&", "&AE346&" "&AF346),(AB346&",
"&AC346&", "&AD346&", "&AE346&" "&AF346))

thanks again