Code for excel copying multiple cells in to one cell with ; symbol in-between text.

Hi can anyone help :-)

I need a vba/ macro code if anyone is up to the challenge

I have cells A1 to I1 that I want copying into one cell N1 with this ; in-between the text and there are 2100 rows. I cant do it any other way as some of the cells are blank therefore i don't want a load of these ; because of the blank cells.

Please help...........


James

There is probably a formula way to do this which would be faster. Either way here you go.

Please Login or Register  to view this content.

Hi thanks for this however for some reason its not doing anything

Got it its because it was sheet 5! thank you so much!!!!!!!!!!! :-)