MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

A Paragraphs in one cells --> convert into a line in per cells

  Asked By: Lambodar    Date: Nov 13    Category: MS Office    Views: 2598

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



1 Answer Found

Answer #1    Answered By: Ludkhannah Fischer     Answered On: Nov 13

If you are only doing it once I would suggest

Create a new sheet with only the Key(ID Number) cells  and the address cells
Export that to a text file
Open the text file in Excel
(May need a bit of playing around to get this to come up in the right
Use vlookups to get the other data across from the old sheet
Copy the entire sheet and paste special/values