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)
- Convert m3u to mp3 - Guide
- Convert number to words in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Ping to txt file - Guide
- Convert picture to shape powerpoint - 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 ?
