","

Hello Mark,

Hope you enjoyed your Microsoft Excel VBA Advanced course with Best STL.

Thank you for your question regarding what the & "," & means in the code.

To join data together in Excel is known as 'concatenation'. So, in the example you have provided, the code joins together cells.address to entirecolumn.address to entirerow.address with commas separating each item.

Another example using the CONCATENATION function in Excel would be as follows:

Cell A1 contains the heading First Name
Cell A2 contains the heading Last Name
Cell B1 contains the name Mary
Cell B2 contains the name Smith

You want to place both names into one cell.

In cell C2 insert this formula:

=CONCATENATION(A2,B2)

Cell C2 will now show MarySmith (no spaces)

Edit the formula to add a space using &" "&

=CONCATENATION(A2&" "&B2)

Cell C2 will now show Mary Smith



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer