Microsoft excel

hello i would like to know how i would merge cells in microsoft excel. i would like to combine text from multiple cells into one cell seperated with a comma or ; i would like a step by step instruction microsoft excel couldnt give me a good explanation. thanks see attached sample i want to match column D, E , F address city state

 

copy three column in some text editin s/w which can find a tab, replace tab by ";" and paste back again into a single column.

 

well thanks alot but it didnt solve my problem

 

Hi,

The solution to your question is the concatenate function and by using a dummy cell to hold the comma and a space you can achieve this no problem.

The formula I used is

=CONCATENATE(D25,$K$1,E25,$K$1,G25)


First enter the separator you want to use in a random cell.
I entered a comma into cell K1.
Then click on the cell where you want the merged data.
Open the formula wizard and select concatenate.
A window will open asking for each cell reference you want to merge.
Click on your first item of data.
Then click on the cell with the separator you want to use.
and so on until you are done.


I have attached your original spreadsheet with columns D, E , F merged in coumn J with a comma in between each.

I hope that helps.

Mark.

 

Can this cells merging be done in mysql i would like to know thanks