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

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

Get address into 1 cell
 

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.

Get address into 1 cell
 

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

Get address into 1 cell
 

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.

Get address into 1 cell
 

Many thanks Carlo, that was my thought too, but I hoped there might be a way
to do it automatically!
Peter
"carlo" wrote in message
oups.com...
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.