merging text from two cells

M

mariekek5

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting data from one column into two 2
How to convert at single colum list into a multi column table 1
Index / Match / value in a range? 2
Concatenate All Possible Combinations 4
Searching multiple fields and then print the entire row from resul 1
Searching multiple fields and then print the entire row from resul 2
Merge Cells? 2
Counting based upon 2 conditions that are text based 7

Top