Cut-and-paste problem

  • Thread starter Thread starter whatsupdoc205
  • Start date Start date
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.
 
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
 
Back
Top