Get address into 1 cell

[Peter]

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

 

[carlo]

Doubleclick in the cell.

Then it should paste all in the same cell.

hth

Carlo

 

[RobertLRoyer]

Doubleclick in the cell.

Then it should paste all in the same cell.

hth

Carlo



- 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.

 

[Peter]

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
Peter

 

[carlo]

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






- Show quoted text -

I think you need to resize it afterwards again.

 

[Peter]

Many thanks Carlo, that was my thought too, but I hoped there might be a way
to do it automatically!
Peter