I would wondering if there are any hints that can assist me to
convert all my old work book format ...where in the past we used one
paragraphs per cells.. and now we would like to make it to one
cells.. one line


for example (i use my country add)


Cells - C1 contains
-- 2, Jalan Bukit Permai 2/3 (Alt Enter)
-- Taman Bukit Permai 2/3 (Alt Enter)


and I would like to change it to

Sheet 2 - C1 - 2, Jalan Bukit Permai 2/3
D1 - Taman Bukit Permai


To converts paragraphs into many line