Combining Cells

[PIJim]

I have a few hundred cells that I would like to combine. Each cell contains a six digit code number. I would like to combine the cells with a semicolon and a space between each code number.

I can do this with the CONCATENATE function but it will take too long.

Any ideas?

Thanks,
Jim

 

[PIJim]

Thanks to ALL!

Willem's last solution was the easiest for me to use / understand

Thanks

 

[Willem!]

Glad I could assist!