concatenate not working

  • Thread starter Thread starter Ralph
  • Start date Start date
R

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.
 
It sounds like the cell you have your formula in is formatted as Text.
Change its format to General and re-enter the formula.
 
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
 
I played with it and got this to work:

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

thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Excel Macro in Access 0
Average last 4 entries in a row. 8
Vlookup problem 3
magic cell 9
Simplify Cell Formulas - AGAIN 1
lookup and concatenate 4
if (and) question 5
Dare Format 4

Back
Top