How do i convert a vertical column of numbers to horizontal row of comma separated values?

**kingpoop** · 09-25-2014, 01:14 PM

Hello All,

if I have a vertical column of numbers such as column A going up to 5000 in Column A of Sheet 1
how can I convert column A to a comma separated list of numbers and insert starting at Column B?

I have the following code so far:

Please Login or Register  to view this content.

1
2
3
4
5
6
7
8
9
10

and looking to do this: '1','2','3','4',...

Thanks for your help.

**Bernie Deitrick** · 09-25-2014, 01:45 PM

Please Login or Register  to view this content.

**Leith Ross** · 09-25-2014, 01:50 PM

Hello kingpoop,

Here is macro to take the values in "A1:A10" and create a comma separated list in "B1".

Please Login or Register  to view this content.

**Bernie Deitrick** · 09-25-2014, 02:14 PM

I like your use of Join, though to meet the OP's needs:

Please Login or Register  to view this content.

How do i convert a vertical column of numbers to horizontal row of comma separated values?

LinkBack

Thread Tools

Rate This Thread

Display

How do i convert a vertical column of numbers to horizontal row of comma separated values?

Re: How do i convert a vertical column of numbers to horizontal row of comma separated val

Re: How do i convert a vertical column of numbers to horizontal row of comma separated val

Re: How do i convert a vertical column of numbers to horizontal row of comma separated val

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Take Column Values (Varying Size) and Transform into 1 Line: Comma AND ' Separated Values

Programatically Convert comma separated 'Text to Column'

Comma separated list with vertical lookup

Convert Horizontal data into a 'Cummulative' (one-column) Vertical List

Excel 2007 : One column to txt comma separated values

Bookmarks

Bookmarks

Posting Permissions