Thread: Unwanted Quotes
View Single Post
  #8   Report Post  
Michael
 
Posts: n/a
Default

Thanks very much for your tip, Gary's Student. I learned something new today!
--
Sincerely, Michael Colvin


"Gary's Student" wrote:

You are trying to copy from the cell - not good

Instead select the cell and copy directly from the Formula Bar; when you
paste into Notpad the quotes will be missing.


Have a good day!
--
Gary's Student


"mas_detokyo" wrote:


If you want to copy it with CTRL+C, I believe you have to clean up the
character by clean function.
e.g. You have text in cell A1 with ALT+ENTER. Then put "=CLEAN(A1)" in
cell B1. Then copy from B1 to another program.
mas


--
mas_detokyo


------------------------------------------------------------------------
mas_detokyo's Profile: http://www.excelforum.com/member.php...o&userid=26712
View this thread: http://www.excelforum.com/showthread...hreadid=401455