ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Address information in each cell (https://www.excelbanter.com/excel-discussion-misc-queries/117949-address-information-each-cell.html)

scubadiver

Address information in each cell
 
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...


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com