Concatenate Function will not work

[Chuck W]

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

 

[Michael]

Hi Chuck

Try this:

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

HTH
Michael

 

[Bob Phillips]

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

--

HTH

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[Gord Dibben]

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