Combine cells to one cell

Hi,

I have a set of data that I need to combine 50 or so cells into one cell with a semicolon. Here's an example:

Data in Column (multilple cells)
12
34
56
78
90
89
45
80

I need to combine to one cell as follows:
12;34;56;78;90;89;89;45;80


The data could be 10 rows or 100 rows. Any help would be much appreciated!

Thanks,
Mike

Here's one approach, assuming data in column A starting in A1.

Please Login or Register  to view this content.

Worked perfectly.....Thanks so much for the prompt response!!!