Pasting text into Excel 97

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mail Man Bob - 27 Aug 2007 16:50 GMT

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

Reply to this Message

etradeguru@hotmail.com - 28 Aug 2007 11:26 GMT

> 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

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

Reply to this Message

Sandy Mann - 28 Aug 2007 11:45 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
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

Reply to this Message

Rate this thread: