help with addresses in rows

[johndh]

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

 

[Mark K]

Do you want to leave the values in column A, or actually move them? I
you want to leave them in column A, just put the folowing in (B1) t
(C1) and copy them down every 4 rows:

(B1)
=if(A1="","",A1)

(C1)
=if(A2="","",A2)

(D1)
=if(A3="","",A2)

This will leave the cells empty if there's nothing in the A column an
display it when there is data

 

[johndh]

Thanks Mark for your help,Yes I want to delete column A and just have
the rows in that format that you gave me.I have about 3000 entries to
make tho.