Mergeing Cells

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
 
M

Meebers

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

maths15

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

why do I get an error message when i try to merge cells? 5
Insert a semicolon in lieu of ALT Enter 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Critical - Converting Single Column Address Data into Multiple Col 2
VBA set thick borders around non empty cells in range 0
Splitting Text from single cell in column across multiple Columns 3
conditional formatting based on relative cell value 2
how do I unmerge data in a column and distribute in rows? 7

Top