Sequence number.

[serge]

Hello,

I'm looking for a formula that will return a column of numbers into a row with each number separated by a comma and one space like the example below, the column can go up to thousands of numbers.
It's to copy and past into a program software.
Thank you

 

[hagia_sofia]

Hello, it might not be a very elegant solution but could e.g. use the following formula & copy it from bottom (B14) to top and then use the result in B3 (also you might probably need to pay attention to the maximum number of characters in a single cell):

=IF(B15="",A14,A14&", "&B15)

 

[serge]

Hi hagia_sofia, thank you for the help it works.
Could you have a formula that would return only the top row ?

 

[hagia_sofia]

Many thanks for the feedback. I am not sure whether it is possible with Excel 2007 but maybe somebody will have an idea (an alternative that comes to my mind is to copy the values into Word and replacing ends of paragraphs).

 

[Scott Huish]

Here's a UDF:

Function transposeit(r As Range)
transposeit = Join(Application.Transpose(r), ", ")
End Function

Then you could do something like:
=TRANSPOSEIT(A3:A14)