Mergeing Cells

  • Thread starter Thread starter maths15
  • Start date Start date
M

maths15

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.
 
Meebers said:
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.




tHANKS
Click to expand...

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
 
Back
Top