I am trying to fix up a poorly designed Access database.

One of the tables has a Next of Kin field in which the typical entry looks
like this once it has been exported to Excel:

Mary Smith



Next of Kin:

Notify:



Mr. & Mrs. John M. Smith

(Parents)

(live with Son,Gerard)



Mr.Gerard H. Smith (brother)

1234 Brookside BLVD.

Kansas City, MO 12345

Tel: 1-816-123-4567

Mrs. Regina Thomas (sister)

123 Beech St.

Worcester, PA 12345

Tel. 1-215-123-4567

Within the field there are paragraph entries.

I exported it to Excel in hopes of deleting some of the extraneous material
and then separating the data into columns using Text to Columns.

In the cell the paragraph marks show up as bangs; in the formula field at
the top the bangs show up as tiny squares.

When I try to to do a Find and Replace, I can delete text, but I am still
left with the bangs. I also cant deal with the Text to Columns because of
the bangs.

My hope had been to setup the fields correctly in Excel and then import them
to a new Access table set up properly. Is there any way of doing this or is
the best thing to simply keep the Excel table open and type the data into an
Access Form? There are many records:(

Thank you for any help given.

Mary