Convert excel data(.xls) to text file(.txt)

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

3 replies

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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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 ?
i dont know hahahaha