ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to Paste Unformatted Text Into Excel (https://www.excelbanter.com/excel-programming/403764-macro-paste-unformatted-text-into-excel.html)

Jim Patterson

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

JLGWhiz

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


Susan

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



jayray

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.

Jim Patterson

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



All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com