Thread: [Solved] Removing Quotes from a Pasted Result
View Single Post
 
Old 08-14-2019, 10:54 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
<Copy this and paste it into a notepad>
(Somehow I can't put any tags into my post!?)

This is not an Excel problem really! It looks like copying the formula result out of Excel/MS Office puts quotes there.


When you replace formulas with values (Copy>PasteSpecial.Values), then the string will be pasted without quotes.
Reply With Quote