View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carlo carlo is offline
external usenet poster
 
Posts: 367
Default Get address into 1 cell

Doubleclick in the cell.

Then it should paste all in the same cell.

hth

Carlo

On Nov 6, 8:19 am, "Peter" wrote:
Hi, I am trying to copy an address from a screen in IE7 and insert it into 1
cell of a spreadsheet, the problem I keep running into is that I copy the
address then try to paste it but instead of going into cell A3, where I want
it, it puts the first line into A3, the 2nd line into A4 and the third line
into A5. I thought I might be able to do something with paste special, but
the options I get will not allow me to achive what I want.
I really do hope someone out there can give me a pointer on how to solve
this problem
Thanks in advance
Peter