View original (French)

Insert double quotes in the data of a column in Excel (2007)

Solved
cs_douda06 Posted messages 68 Status Member -  
 Dan28 -
Hello,

In an Excel column, I have values without double quotes aaa, and I would like to add double quotes so that all the data looks like this "aaa".

How can I apply this in a specific column using a formula or a macro, please?

Thank you in advance.

1 answer

  1. Yoda
     
    Hello,

    For the formula, if the original data is in column A

    =CHAR(34) & A1 & CHAR(34)

    Then copy the formula to the destination column.

    A+
    2
    1. cs_douda06 Posted messages 68 Status Member
       
      Hello Yoda, I selected column A, then I pasted the formula into the formula box, but after that, I don't know how it works to see the result in the destination column!! Can you explain the steps to me, please?
      0
      1. Yoda > cs_douda06 Posted messages 68 Status Member
         
        for example, in A1 (source cell) you have aaa
        you go to B1 (destination cell) and type =CHAR(34) & A1 & CHAR(34), and press Enter
        the value of B1 becomes "aaa"
        Then you can copy the formula (cell B1) to cells B2, B3,... Bn

        See you later
        0
    2. cs_douda06 Posted messages 68 Status Member
       
      Thank you very much, Yoda :)
      0
    3. Dan28
       
      Great. Thank you very much :)

      I wanted to put an apostrophe. And it works very well with the ASCII code =CHAR(39) & A1 & CHAR(39)
      0