Finally i have found a solution with this formula:
![]()
Please Login or Register to view this content.
Ok this is the new macro that works:
info![]()
Please Login or Register to view this content.
Heres an example:This Macro Merge Columns T,U,V,W,X,Y,Z,AA,AB,AC into AD Column and separates values by comma and ignores blank cells. After that it copies the results into AE Column and deletes the unnecessary Columns. So when the macro executes completely you have all this Columns merged into T Column
IMAGE_1 IMAGE_2 IMAGE_3 MERGED_IMAGES myimage1.jpg myimage2.jpg myimage3.jpg myimage1.jpg,myimage2.jpg,myimage3.jpg myimage1_b.jpg myimage2_b.jpg myimage3_b.jpg myimage1_b.jpg,myimage2_b.jpg,myimage3_b.jpg myimage1_c.jpg myimage2_c.jpg myimage3_c.jpg myimage1_c.jpg,myimage2_c.jpg,myimage3_c.jpg
PS!!!
I have found a second problem, after the macro executes i have found some cells with an unneeded comma in the end of the cell value.
So i have create a second macro to fix that problem with the macro recorder and this formula
You can change the formula to whatever you want, eg if you want to remove the "w" character in the end of the value of A2 cell you can change the formulla like this:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks