Hi

I have a database of addresses in excel. In column A is the 1st line of the
address, column B line 2 of the address and so on and so forth. What I would
like to do is merge the each line of the address cell so the full address
appears in one cell. Anyone have any idea how to do this?


Thanks

Mark

=CONCATENATE(A1," ",A2)
=A1&" "&A2


Regards,
Ryan---

--
RyGuy


"maths15" wrote:

Hi

I have a database of addresses in excel. In column A is the 1st line of the
address, column B line 2 of the address and so on and so forth. What I would
like to do is merge the each line of the address cell so the full address
appears in one cell. Anyone have any idea how to do this?


Thanks

Mark

In the cell that you want the completed address type =a1&" "&b1. (assume
a1 = first name? and b1 = last name?) Then you should copy/paste
special/value to make it permanent instead of a result of a formula.

"maths15" wrote in message
...
Hi

I have a database of addresses in excel. In column A is the 1st line of
the
address, column B line 2 of the address and so on and so forth. What I
would
like to do is merge the each line of the address cell so the full address
appears in one cell. Anyone have any idea how to do this?


Thanks

Mark

"Meebers" wrote:

In the cell that you want the completed address type =a1&" "&b1. (assume
a1 = first name? and b1 = last name?) Then you should copy/paste
special/value to make it permanent instead of a result of a formula.

"maths15" wrote in message
...
Hi

I have a database of addresses in excel. In column A is the 1st line of
the
address, column B line 2 of the address and so on and so forth. What I
would
like to do is merge the each line of the address cell so the full address
appears in one cell. Anyone have any idea how to do this?


Thanks

Mark



tHANKS

Both these replies worked, thanks a lot :)

Mark

Just a note here.

If you have a specific reason for this, go ahead but having all in one cell can
lead to problems later with sorting, filtering, mailing lists, etc.

Suggest you keep a copy of the original data in it's current format.


Gord Dibben MS Excel MVP

On Mon, 7 Apr 2008 13:59:04 -0700, maths15
wrote:



"Meebers" wrote:

In the cell that you want the completed address type =a1&" "&b1. (assume
a1 = first name? and b1 = last name?) Then you should copy/paste
special/value to make it permanent instead of a result of a formula.

"maths15" wrote in message
...
Hi

I have a database of addresses in excel. In column A is the 1st line of
the
address, column B line 2 of the address and so on and so forth. What I
would
like to do is merge the each line of the address cell so the full address
appears in one cell. Anyone have any idea how to do this?


Thanks

Mark



tHANKS

Both these replies worked, thanks a lot :)

Mark