I have copied and pasted address information from an Access Database.

The problem is that most of the addresses have components that are listed on
separate lines within each cell rather than one line. How can I easily
transform the information so the address appears on one line...