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
|