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.

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

--
Rick (MVP - Excel)


"Ralph" wrote in message
...
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.

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

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)


"Ralph" wrote in message
...
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.

I played with it and got this to work:

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

thanks again

"Ralph" wrote:

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

"Rick Rothstein" wrote:

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

--
Rick (MVP - Excel)


"Ralph" wrote in message
...
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.