Convert excel data(.xls) to text file(.txt)
Closed
                                    
                        shebeershah                    
                                    -
                            Dec 20, 2009 at 01:48 AM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 04:53 PM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 04:53 PM
        Related:         
- Convert excel data(.xls) to text file(.txt)
- Ping to txt file - Guide
- How to convert number to words in excel - Guide
- How to open excel file in notepad - Guide
- Windows 10 iso file download 64-bit - Download - Windows
- Transfer data from one excel worksheet to another automatically - Guide
3 responses
                        
                    Well my easiest solution would be to Delete Column A, (it can be undone) or if too many columns need to be deleted work on copy of worksheet. 
then Save as "other Formats"
Pick type text (tab delimited)
Save and it is done.
            then Save as "other Formats"
Pick type text (tab delimited)
Save and it is done.
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Apr 15, 2010 at 04:53 PM
    Apr 15, 2010 at 04:53 PM
                        
                    Manually ?
Copy Col B to a new sheet
then copy col C just after where col B data ended
then copy col D
Or are you looking for macro ?
            Copy Col B to a new sheet
then copy col C just after where col B data ended
then copy col D
Or are you looking for macro ?
