View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Want to paste ASCII, not "formatted"

Hi KHashmi316, (a real name is preferred in Excel newsgroups)
I don't see how the first answer Paste Special was not considered
globally available. Anyway a macro was provided with suggestions
of where to put it. But I think there is a better more general purpose answer
that you could use across all Windows applications (on a PC anyway).

You can install Pure Text then you will have a button on your
system task bar. Copy text from anywhere, use the PureText (PT)
button and the data in the clipboard is text retaining LF (line feed).

PureText,2.0, Steve P.Miller, paste copied text as simple text into
another application without getting all the formatting from the original source
http://www.stevemiller.net/puretext/
download: PureText 2.0 for Windows 95/98/Me/NT/2000/XP/2003 [13k]

Since you are posting to newsgroups, you should learn to use newsgroups
as newsgroups rather than using a web site that messes up web page
searching. I would certainly discourage the use of posting to newsgroups
via Forums. http://www.mvps.org/dmcritchie/excel/xlnews.htm#forums

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm