View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] whatsupdoc205@hotmail.com is offline
external usenet poster
 
Posts: 7
Default Cut-and-paste problem

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.