View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mariekek5 mariekek5 is offline
external usenet poster
 
Posts: 62
Default merging text from two cells

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