Make a new column. In C1:

=A1 & " " & B1
--
Gary''s Student - gsnu200858


"mariekek5" wrote:

Hi,

Is it possible to merge the text from two colloms.

For instance in column A its says colour en in column B its says animal
species:

A B
Brown Dog
Yellow Bird
White Bear
Black Horse

How can I merge this text in such a way that in one column I will get:

A
Brown dog
Yellow bird
White bear
Black horse

Thanks a lot in advane.

Marieke