You could enter this formula in F1:

=A1&","&B1&","&C1&","&D1&","&E1

and copy down the column. If you want to be left with just this,
highlight the formula cells in column F, click <copy then Edit |
Paste Special | Values (check) | OK followed by <Enter - then you can
delete columns A to E.

Hope this helps.

Pete

On Nov 23, 7:33 pm, Johnny wrote:
my problem is how to create a macro to combin columns(A-E), sometime in
diffrent rows.
this is the sample:
A B C D E
------------------------------------------------------------------------
N6M1(4418 271 -1G)M2(18540 FISH 2589pcs

I want a macro to combin A-E and add a (,)between each columns.
looks like this:N6M1(4418,271,-1G)M2(18540,FISH,2589pcs