Try:

=A1 & A2
or
=A1 & " " & A2 (if you want a space between the two text
items...)

or
=CONCATENATE(A1 & B1)

=CONCATENATE(A1," ",B1) (if you want a space between the two text
items...)


"dziw" <dziw.2bxcus_1154542206.791@excelforum-nospam.com> wrote in message
news:dziw.2bxcus_1154542206.791@excelforum-nospam.com...
>
> If I have two columns which are lists of names, how do I make a new
> column which merges the names from each column into one list, and will
> refresh when new data is added to the two originals.
>
>
> --
> dziw
> ------------------------------------------------------------------------
> dziw's Profile:
> http://www.excelforum.com/member.php...o&userid=10422
> View this thread: http://www.excelforum.com/showthread...hreadid=567563
>