CONCATENATE function for values to be separated by commas

Hey everyone,

I turn to you for a little help. I have in columns A1 thru E1 a series of numbers. I just need a function called "pnezd" to basically grab cell A1 insert a comma after it, then B1 insert a comma after it, then C1 insert a comma after it........ you get the point. Basically I need this:

enter in G1 =pnezd(A1:E1)
and getting the output of values such as: A1,B1,C1,D1,E1

Could you help me out to figure out how to do this with a VBA function

Thank you very much!



dejhantulip

Please Login or Register  to view this content.