If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Want to paste ASCII, not "formatted"
If I paste text *directly* into a cell, Excel formats the text to look like the original. If I paste the text into the formula bar, the text in the cell is ASCII. Is there a way to paste *directly* into the cell, but not have Excel "auto-format"? Thanks for any help you can provide. -- KHashmi316 ------------------------------------------------------------------------ KHashmi316's Profile: http://www.excelforum.com/member.php...o&userid=10439 View this thread: http://www.excelforum.com/showthread...hreadid=504298 |
#2
|
|||
|
|||
Want to paste ASCII, not "formatted"
Hi
PasteSpecialValues -- Arvi Laanemets ( My real mail address: arvi.laanemetsattarkon.ee ) "KHashmi316" wrote in message ... If I paste text *directly* into a cell, Excel formats the text to look like the original. If I paste the text into the formula bar, the text in the cell is ASCII. Is there a way to paste *directly* into the cell, but not have Excel "auto-format"? Thanks for any help you can provide. -- KHashmi316 ------------------------------------------------------------------------ KHashmi316's Profile: http://www.excelforum.com/member.php...o&userid=10439 View this thread: http://www.excelforum.com/showthread...hreadid=504298 |
#3
|
|||
|
|||
Want to paste ASCII, not "formatted"
Arvi Laanemets Wrote: PasteSpecialValues Hi, Avi: Can this be set *globally* somehow (i.e. for all Excel projects)? I didn't see an option in ToolsOptionsEdit. -- KHashmi316 ------------------------------------------------------------------------ KHashmi316's Profile: http://www.excelforum.com/member.php...o&userid=10439 View this thread: http://www.excelforum.com/showthread...hreadid=504298 |
#4
|
|||
|
|||
Want to paste ASCII, not "formatted"
Hi
Instead of workbooks module, save the code in Personal Macro Workbook (Personal.xls) module. When you don't have Personal.xls jet, then easier way to create it at right place is to record a macro to it (ToolsMacroRecord New Macro, select 'Store macro in' = 'Personal Macro Workbook' and press OK. Stop recordig.) Now press Alt+F11, in VBA Project window activate the module of Personal.xls, delete the lately created dummy macro, and copy the UDF code into this module. From now on, this UDF is avaiable for all workbooks opened in this computer. -- Arvi Laanemets ( My real mail address: arvi.laanemetsattarkon.ee ) "KHashmi316" wrote in message ... Arvi Laanemets Wrote: PasteSpecialValues Hi, Avi: Can this be set *globally* somehow (i.e. for all Excel projects)? I didn't see an option in ToolsOptionsEdit. -- KHashmi316 ------------------------------------------------------------------------ KHashmi316's Profile: http://www.excelforum.com/member.php...o&userid=10439 View this thread: http://www.excelforum.com/showthread...hreadid=504298 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Want to paste ASCII, not "formatted"
Sorry! This reply was meant to another thread at all :-((
"Arvi Laanemets" wrote in message ... Hi Instead of workbooks module, save the code in Personal Macro Workbook (Personal.xls) module. When you don't have Personal.xls jet, then easier way to create it at right place is to record a macro to it (ToolsMacroRecord New Macro, select 'Store macro in' = 'Personal Macro Workbook' and press OK. Stop recordig.) Now press Alt+F11, in VBA Project window activate the module of Personal.xls, delete the lately created dummy macro, and copy the UDF code into this module. From now on, this UDF is avaiable for all workbooks opened in this computer. -- Arvi Laanemets ( My real mail address: arvi.laanemetsattarkon.ee ) "KHashmi316" wrote in message ... Arvi Laanemets Wrote: PasteSpecialValues Hi, Avi: Can this be set *globally* somehow (i.e. for all Excel projects)? I didn't see an option in ToolsOptionsEdit. -- KHashmi316 ------------------------------------------------------------------------ KHashmi316's Profile: http://www.excelforum.com/member.php...o&userid=10439 View this thread: http://www.excelforum.com/showthread...hreadid=504298 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding a choice to right-click mouse option in word | xppuser | General Discussion | 16 | February 20th, 2008 06:45 AM |
need custom cut and paste functions | ben | New Users | 0 | January 6th, 2006 04:23 AM |
I cannot paste from one workbook to another. Copy works, paste do. | JimmyMc | General Discussion | 1 | June 10th, 2005 03:54 PM |
Can't paste from clipboard from Access table | M Skabialka | General Discussion | 1 | October 6th, 2004 09:53 PM |
copy, paste, tiny mobile phone icon | Dominic | General Discussions | 8 | July 19th, 2004 10:03 PM |