For example, if I have the address 123 N Main St in four separate cells, I
used the formula =A1&" "&B1&" "&C1&" "&D1 to get it all in one cell, but I
always get the same error code of #VALUE!

I have tried to format everything as text, with no luck. They all started
out as general formatting. I know it's a formatting problem, because if I
just try to combine the last three cells it works fine. When I try to add the
numbered cell to the formula, it won't work. I've tried to re-format, copy
the cells over as text, everything I can think of.


"Niek Otten" wrote:

What formulas? What input values?

--
Kind regards,

Niek Otten

"Dino" wrote in message
...
I have tried to concatenate or use the "&" in my database with no luck so
far. I get either the #VALUE! or #NAME? result. I have addresses that are
separated into columns by number, direction, street, and suite. I want to
combine the numbers and text onto one line, in one column. I've tried
reformatting everything into text or numbers, with no luck. I have done
this
in previous databases before, with no problems. Hopefully someone can
help!