View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Cut-and-paste problem

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

On Mar 23, 3:58*pm, wrote:
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.