Line Break on a specific character

E

Ekser

Ok, so I have a "Template" sheet, that contains only titles and formate
cells to be populated when a macro is activated. After this, the data i
copied into a Word document - the way I've formated it in the "Template
sheet.
One of the cells in this sheet will have some data from a cell i
another sheet("Data") and this cell contains data separated by a comm
(validation list). So, I would like to make sure that when the dat
from "Data" is copied in my "Template" cell - the comma separates th
lines within the cell.

I hope I was clear, it's not easy to explain eventhough it's not
complicated feature I'm looking for... :rolleyes:


Cheers
 
Top