View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default Return while useing CONCATENATE

I have list of cell that I am combining. I need some help in placing a
RETURN so that the combined cells are on more then one like.

example.
From: Project Manager John Doe Section 23
=CONCATENATE(B3," ",B4," ",B5)

To:
Project Manager
John Doe
Section 23

--
Work is sometimes hard....but someone has to do it.