Excel 2007 : Create a single cell from a column of number

[stellm]

I need to create a single cell with a semicolon in between each number from a column of numbers. The list will continually vary in length. Is there a macro or formula that can do this?
Example

17020
17021
17030
17031

Result in a single cell is 17020;17021;17030;17031

Thanks

[Fotis1991]

Ηι

Try this.

=A1&";"&A2&";"&A3&";"&A4&";"&A5

Hope to helps you.

[DGagnon]

you could add a row next to your current data row for example if your data is in Col A starting on row one:

in B1 enter
=A1

in B2 and beyond enter

=B1&";"&A2

[tom1977]

hi
put your data in column A select it and run this code

Please Login or Register  to view this content.

[stellm]

That does work. Is there anyway to automatically change the length or the amount of numbers in the formula? The list may very from 50 to 100? thanks

[DGagnon]

you could use a custom function based on the code that Tom provided as so:

Please Login or Register  to view this content.

then in your worksheet you could call it like this and select any range you needed

=CombineRow(A1:A100)