To copy the cell value as pure text, to achieve what you describe you have to use a macro: Number, General, Text (doesn’t even Concatenate then) - no luck Have you tried changing the format to something other than number? I think I have seen ways around that. Excel - leave out quotes when copying from cell. Getting Rid of Extra Quote Marks in Exported Text Files. create your own macro that creates the output text file. I would suggest using something a little smarter than notepad… You could use MS Word as a go-between from Excel to whatever text editor you wanted to use besides word. It’s going to be up to the editor your putting it into to look after formatting it. Like the previous poster says, it’s just outputting valid CSV data. Then you may copy it again to its final destination, eg notepad. If you copy a range from Excel (2010) to Word, you will get the text as you want it, quotes free. How to copy multi-line text from Excel without quotes?. Can Notepad++ do whatever Word does, to remove quotes, or is there a plugin? Then I can just copy from Excel, and paste into Notepad++
0 kommentar(er)
