Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Problem Between Ex 97 vs 2k | Excel Discussion (Misc queries) | |||
Paste problem | Excel Discussion (Misc queries) | |||
Problem with paste | Excel Worksheet Functions | |||
Paste Problem | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |