View original (French)

Remove parentheses in Excel in a column

ptéranodon Posted messages 465 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   -

Hello everyone

In one Excel column, I have numbers with some of them in parentheses.

How can I remove them?

Indeed, if I go to "find/replace", it will also remove parentheses from my formulas in other columns.

How can I only remove the numbers in parentheses from a single column?

I am using a simplified version of Excel for iPad. Perhaps this explains it.

Maybe there would be a formula to do this?

Note: I just realized that the cells in this column contain formulas; perhaps this explains it?

Is there a solution?

Thank you

4 answers

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     

    Hello everyone,

    = substitute(substitute(a1;")";"") ;"(";"")


    Best regards

    0
  2. ptéranodon Posted messages 465 Registration date   Status Member Last intervention   4
     

    Thank you DjiDji

    I entered:

    = substitute(substitute(A2;")";"") ;"(";"")

    In column X

    I have the error:

    #NAME?

    0
    1. bigoudiii Posted messages 276 Registration date   Status Member Last intervention   91
       

      Hello,

      = SUBSTITUTE(SUBSTITUTE(A2,")",""),"(","")

      0
    2. DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
       

      Light dyslexia. Sorry


      Regards

      0
  3. ptéranodon Posted messages 465 Registration date   Status Member Last intervention   4
     

    Thank you ;)

    0
  4. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     

    Hello.

    "I have numbers, some of which are in parentheses. How can I remove them?"
    Remove the numbers or the parentheses?

    "How can I remove only the numbers in parentheses from a single column?"
    Simply select the relevant column, and only that one ...

    Retirement is great! Especially in the Caribbean ...
    Raymond (INSA, AFPA)

    0