| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with addresses in rows
When pasting addresses like on the left,how can I get them to look like
the right side.Is there a way to automate this so when I paste in columns,it will appear in rows. from this to this (A1) 527 Bloor St W (B1) 527 bloor St W (A2) Toronto,ON M5S 1Y5 CA (C1) Toronto,ON M5S 1Y5 CA (A3) Tel: (416) 534-0196 (D1) Tel: (416) 534-0196 (A5) 1110 Bathurst St (B2) 1110 Bathurst St (A6) Toronto,ON M5R 3H2 CA (C2) Toronto,ON M5R 3H2 CA (A7) Tel: (416) 516-6161 (D2) Tel: (416) 516-6161 (A9) 334 Bloor St W (B3) 334 Bloor St W (A10) Toronto,ON M5S 1W9 CA (C3) Toronto,ON M5S 1W9 CA (A11) Tel: (416) 928-9603 (D3) Tel: (416) 928-9603 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| odd and even addresses | Excel Worksheet Functions | |||
| Addresses | Excel Discussion (Misc queries) | |||
| Help with Addresses | New Users to Excel | |||
| How do I convert a single column of addresses into rows for export | Excel Discussion (Misc queries) | |||
| 2 rows of email addresses! | Excel Programming | |||
Threaded Mode
