Cut-and-paste problem

W

whatsupdoc205

When I cut two adjacent columns from a worksheet and paste them into
Notepad, I lose the indentation in the second column, which is
formatted as Text. Also, the first column, which is formatted as
General and contains numeric formulas, becomes left-adjusted instead
of being right-adjusted, as it is in the worksheet.

My intent is to capture the information into a plain ASCII "txt"
file. Is there any way to accomplish that and preserve the
indentation and "adjustment" of the data in the worksheet?

I tried saving the workbook (after removing extraneous data) as both
Unicode and tab-delimited Text files, to no avail.
 
P

Pete_UK

A text file is just that - a file containing text characters. You
could impose a structure on those characters, eg by wrapping them with
quotes and separating them with commas (i.e. a .csv file), but it is
up to the receiving program to interpret what those structural
characters mean.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top