Need concatenate syntax to concat multiple columns with delimiter (,)

Hi All,

I need code in vba to concat multiple columns. My scenario is we have data in column A to G, where a1 to G1 are headers. Need to concat the columns like a2,b2,c2,d2,e2,f2,g2 till a50,b50,c50,d50,e50,f50,g50... (eg: '101', 'Arun','11001','12/25/1990','32-A, Sabarna Flats','Mumbai','50000').

Thanks in advance,

K@v!..

use one of snb's solution: http://www.snb-vba.eu/VBA_UserDefinedFunctions_en.html

You probably need:
concatenate values in a row without blanks specifying the separator

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Places results in Column H.

Thanq all for ur replies