Excel - formula with quotation mark is been exported to .txt file or even copy/past to a txt file - how to avoid this?

ANJO - Renato Pereira 1 Reputation point
2022-09-02T18:12:29.833+00:00

Hi,

I´m reproducing an error that some user here is facing regargind a formula exporting results with quotation mark - not desired; how to fix it?

237376-image.png

  • As you can see, not only the QUOTATION MARK is beeing exported but also duplicated.
Microsoft 365 and Office | Excel | For business | Windows
{count} votes

2 answers

Sort by: Most helpful
  1. ANJO - Renato Pereira 1 Reputation point
    2022-09-02T19:45:36.743+00:00

    Curious: When past on Word app, works as expected - without duplicated QUOTATION MARK....

    0 comments No comments

  2. Emily Hua-MSFT 27,796 Reputation points
    2022-09-05T04:32:15.783+00:00

    Hi @ANJO - Renato Pereira

    Based on my tests, the line break generated by CHAR(10) causes quotation marks in .txt file as quotation marks in this scenarios help demarcate "the copied text with multiple lines".
    But if pasted in Word, there will be no quotation marks, so some users will use this as a workaround.

    Here is a similar thread: "Why is Excel adding quotes when I copy a cell with lines breaks???“. And Cliff Gu found a VBA code, hope it could be helpful to you.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.