On Nov 7, 1:30 am, "Peter" wrote:
Many thanks, that works a treat, the only thing is that it enlarges the cell
to accomodate the address, is there a way of forcing the cell to remain a
preset size. I should only need to look at the address rarely and in normal
circumstances only when I do a mailshot. Many thanks
wrote in message

ups.com...



On Nov 5, 7:08 pm, carlo wrote:
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- Hide quoted text -

- Show quoted text -

Alternatively, paste it normally. This will keep your fields in
separate cells. Next, create a function in the cell just to the right.
=A3&" "&A4&" "&A5.
This will combine the fields and leave spaces between them.- Hide quoted text -

- Show quoted text -

I think you need to resize it afterwards again.