Data from Excel has Alt enter in a cell

[newbee]

I am creating a report in access. one column in the record is the address. The address came from an excel document that had an alt enter in the cell. The address in the report puts the address on one line with no space between the street name and the city. Is there an easy way to put the address on the two lines like it is in excel or put a space in between the street name and city?


Example: This is what the address looks like now:123 Miranda DrDallas, TX 76502

I would like the address to look like either:

123 Miranda Dr Dallas, TX 76502

or 123 Miranda Dr
Dallas, TX 76502
Thanks for any help. I know I could change it in Excel first but would rather not since there is so much data already in my database.

[June7]

Does the Alt+Enter show as an odd character in the Access table?

Options:

1. run UPDATE query on the field to replace the Excel Alt+Enter (I think is Chr(10)) with space or CrLf characters:

UPDATE tablename SET fieldname = Replace(fieldname, Chr(10), " ")
or
UPDATE tablename SET fieldname = Replace(fieldname, Chr(10), Chr(13) & Chr(10))

2. parse the address parts to separate fields, which is how that really should be in table, this could mean VBA code