ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column of Numbers in xls to String of Numbers in txt (https://www.excelbanter.com/excel-discussion-misc-queries/77534-column-numbers-xls-string-numbers-txt.html)

Spyder

Column of Numbers in xls to String of Numbers in txt
 
Is there an easy way to pull a single column of numbers from a worksheet with
multiple columns and export it to a comma deliniated string of text?

Thanks!
Jeff

Tom Ogilvy

Column of Numbers in xls to String of Numbers in txt
 
open a new workbook.

copy the data you want to the new workbook starting in A1

do a file = Save As and select CSV.

--
Regards,
Tom Ogilvy


"Spyder" wrote:

Is there an easy way to pull a single column of numbers from a worksheet with
multiple columns and export it to a comma deliniated string of text?

Thanks!
Jeff



All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com