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
Hello,

i wanna know how to convert excel data(particular columns data only) to text file in single column???

For Eg:

I have data in column A, B, C,D
like
A B C D
1256 1895 14589 BHT
1234 9518 153 DRT
1258 1545 1896 JYU

Now i want to convert the data of B,C,D to text file(not A) in single column

Like
1895
9518
1545
14589
BHT
DRT
JYU

is it possible ???

Regards

shebeershah
Related:

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.
1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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 ?
0
i dont know hahahaha
-3