ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to move data from single to multible collums in excel (https://www.excelbanter.com/excel-worksheet-functions/208033-how-move-data-single-multible-collums-excel.html)

Don

how to move data from single to multible collums in excel
 
I'm trying to move grouped data from a single collum to multible collums.
Each group is separate by a comma

Max

how to move data from single to multible collums in excel
 
I'm trying to move grouped data from a single collum to multiple collums.
Each group is separate by a comma


Try Data Text to Columns, delimiter: comma
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---

Roger Govier[_3_]

how to move data from single to multible collums in excel
 
Hi Don

Ensure that you have sufficient blank columns to the right of your column of
data.
DataText to ColumnsDelimitedtick CommaFinish

--
Regards
Roger Govier

"Don" wrote in message
...
I'm trying to move grouped data from a single collum to multible collums.
Each group is separate by a comma




All times are GMT +1. The time now is 04:14 AM.

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