Thread: need a macro..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny Johnny is offline
external usenet poster
 
Posts: 126
Default need a macro..

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