ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   using excel wizard for file download which contain many fields (https://www.excelbanter.com/excel-programming/374937-using-excel-wizard-file-download-contain-many-fields.html)

goldfufu

using excel wizard for file download which contain many fields
 
How do I use the excel wizard to separate fields of datas. My downloaded file
usually contains text and number data in many different fields. I am
currently doing it wizard with lines, but it still looks terrible and needs
lots of work to get the file looks presentable. Long time ago, someone had
shown me how to use (*) once. Any suggetions will be appreciated!

Thanks,
Goldfufu

Carim

using excel wizard for file download which contain many fields
 
Hi,

Take a look at Data Texttocolumn ...

HTH
Carim



All times are GMT +1. The time now is 02:58 AM.

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