View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter[_5_] Peter[_5_] is offline
external usenet poster
 
Posts: 8
Default Get address into 1 cell

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