Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Macro to Paste Unformatted Text Into Excel

Does anyone know how to create a macro that will paste unformatted text into
Excel?

Thanks in Advance,
--
Jim Patterson
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Macro to Paste Unformatted Text Into Excel

Look at this:

http://www.cnet.com/8301-13880_1-9834110-68.html

"Jim Patterson" wrote:

Does anyone know how to create a macro that will paste unformatted text into
Excel?

Thanks in Advance,
--
Jim Patterson

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default Macro to Paste Unformatted Text Into Excel

plain 'ole "Paste Values" has always worked fine for me..............
put it on a button up in my toolbar. if you customize your toolbar,
you'll find it listed under "edit". there's a "12" on the button.
hth
susan




On Jan 7, 8:54*am, Jim Patterson
wrote:
Does anyone know how to create a macro that will paste unformatted text into
Excel?

Thanks in Advance,
--
Jim Patterson


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default Macro to Paste Unformatted Text Into Excel

On Jan 7, 8:54*am, Jim Patterson
wrote:
Does anyone know how to create a macro that will paste unformatted text into
Excel?

Thanks in Advance,
--
Jim Patterson


Set the record macro on, go through the paste sequence, stop the
recording, and use the recorded macro. Edit as necessary.
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Macro to Paste Unformatted Text Into Excel

Thanks, it works great!!!!
--
Jim Patterson


"JLGWhiz" wrote:

Look at this:

http://www.cnet.com/8301-13880_1-9834110-68.html

"Jim Patterson" wrote:

Does anyone know how to create a macro that will paste unformatted text into
Excel?

Thanks in Advance,
--
Jim Patterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste unformatted text GregNga Excel Discussion (Misc queries) 9 August 27th 08 01:02 PM
Paste Special\Unformatted Text\Display as Icon sam Excel Discussion (Misc queries) 0 January 8th 08 03:46 PM
Pasting unformatted text into Notepad (from a range in Excel) Daniel Excel Programming 5 October 10th 07 06:58 PM
PASTE UNFORMATTED TEXT INTO WORD, DOES ANYBODY REALLY KNOWS? Daniel Excel Programming 5 October 10th 07 03:20 PM
Exporting Excel Data As Unformatted Text monir Excel Programming 1 June 3rd 06 05:34 PM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"