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

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

--
Mark
-----------------------------------------------------------------------
Mark K's Profile: http://www.excelforum.com/member.php...fo&userid=1411
View this thread: http://www.excelforum.com/showthread.php?threadid=57401

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.
Mark K wrote:
Do you want to leave the values in column A, or actually move them? If
you want to leave them in column A, just put the folowing in (B1) to
(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 and
display it when there is data.


--
Mark K
------------------------------------------------------------------------
Mark K's Profile: http://www.excelforum.com/member.php...o&userid=14117
View this thread: http://www.excelforum.com/showthread...hreadid=574018