Concatenate Function will not work
 

Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck

Hi Chuck

Try this:

=A2&" "&B2&" "&C2&" "&D2
The inverted commas between each cell will give you a space between each
value

HTH
Michael

"Chuck W" wrote:

Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck

=A2&" "&B2&" "&C2&" "&D2&" "&E2

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chuck W" wrote in message
...
Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck

Chuck

I suspect that whilst you have been changing the format to text, it has
stuck at that as the formula works for me. You could try deleting your
existing rows/columns or set it up on a new sheet and see if it works there.

You can also avoid the concatenate function with a simple

=A2&B2&C2....etc

I doubt this will make any difference though

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Chuck W" wrote in message
...
Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck

Chuck

You either have Formula View set to on or your cell with the formula is
formatted as text.

1. Hit CTRL + `(backquote above TAB key) to toggle view formulas off.

2. Format the formula cell as General then hit F2 then ENTER key.


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 13:36:30 -0800, "Chuck W"
wrote:

Hi,

I am having trouble getting the concatenate function to
work. There are five columns of data I am trying to
combine which include Address1, Address2, City, State and
Zip. I have tried changing to formats from general to
text but they will not concatenate. Whenever I use the
function wizard, it simply says =concatenate
(a2,b2,c2,d2,d2) rather than combining my fields. Is
there setting I need to adjust?

Thanks,

Chuck