Re: [ExcelVBA] Transpose and Insert Commas, I don't have a clue how to do this

 

Hello all,
 
I have a column of Excel data that is all numbers, about 15,000 or so, one number in each cell at present.
 
However, I want to turn that column into a row, where all the data can be seen from a single cell in that row.
 
Example, I want to turn this:
 98164754
15642829
15636430
15699463
15600864
15652140
 
Into this, no spaces, but a comma between each number:
 
98164754,15642829,15636430,15699463,15600864,15652140
 
Exactly how do I do this?  Because, I know one simply fact, I am NOT doing this manually.
 
Eric

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 14

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___