View original (French)

Remove parentheses in Excel in a column

ptéranodon Posted messages 465 Registration date   Status Membre Last intervention   -  
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur 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 réponses

Réponse 1 / 4
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716
 

Hello everyone,

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


Best regards
0
Réponse 2 / 4
ptéranodon Posted messages 465 Registration date   Status Membre Last intervention   4
 

Thank you DjiDji

I entered:

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

In column X

I have the error:

#NAME?
0
bigoudiii Posted messages 276 Registration date   Status Membre Last intervention   91
 

Hello,

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

0
DjiDji59430 Posted messages 4277 Registration date   Status Membre Last intervention   716
 

Light dyslexia. Sorry


Regards

0
Réponse 3 / 4
ptéranodon Posted messages 465 Registration date   Status Membre Last intervention   4
 

Thank you ;)
0
Réponse 4 / 4
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 

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