Hi,

=A1&", "&B1

This would concatenate the contents of A1 and B1 in a new cell with a comma
and a space between them.

There are few if any reasons to use the CONCATENATION function instead of &.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Daphtg" wrote:

how do you combine column content as in number in address and street name?