Save "Wrapped Text" data in .txt file keeping all the line separation

asif_raza

New Member
Joined
Sep 26, 2011
Messages
13
I have data in same column. It is wrapped text. Each cell needs to be saved as .txt file. Whenever I copy and paste data in txt file it shows in one single line. But with double clicking into cell and then select data and copy it into .txt it saves the wrapped text version just as required.

Can someone provide VBA to help me out? Its algorithm is something like this

- Double click into cell, Press F2

- Select all data in cell and copy it

- Open an input folder, create .txt file and paste date there. save it before closing it
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,095,360
Messages
5,444,010
Members
405,260
Latest member
Khauff

This Week's Hot Topics

Top