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