Pasting text into Excel 97

  • Thread starter Thread starter Mail Man Bob
  • Start date Start date
M

Mail Man Bob

When I copy text from within an email body to Excel 97, it is always formatted differently from the Excel document, that is, both wrapped text and merge cells are checked. I would like it to remain unformatted - any way to do this without having to reformat the copied text after pasting each time?

Thanks!

Bob
 
When I copy text from within an email body to Excel 97, it is always formatted differently from the Excel document, that is, both wrapped text and merge cells are checked. I would like it to remain unformatted - any way to do this without having to reformat the copied text after pasting each time?

Thanks!

Bob
Click to expand...

Bob,
The easiest way I know is to paste the text into Notepad, save it.
This normally strips out formatting.
You can then either copy the text again and paste into Excel or you
can open the text file with Excel and use the text import wizard.
Mark
 
Bob,

Another way that I use is to copy and Paste Special > Unicode Text

Then if necessary, Data > Text to Columns > Delimited > Next > (usually)
Space > Finish

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


When I copy text from within an email body to Excel 97, it is always
formatted differently from the Excel document, that is, both wrapped text
and merge cells are checked. I would like it to remain unformatted - any
way to do this without having to reformat the copied text after pasting each
time?

Thanks!

Bob
 
Back
Top