mardi 1 décembre 2015

Need 3 outcomes from IF statment

I have a list of names in excel which have a random number next to them in brackets, the numbers are 1 to 3 digits long. I was using the formula

=IF(LEFT(RIGHT(B8,4),1)=("("),RIGHT(B8,3),RIGHT(B8,4)) to get rid of the first bracket and then 
=IF(RIGHT(LEFT(AX8,3),1)=")",LEFT(AX8,2),LEFT(AX8,3)) to remove the last bracket. 

This was working until I found a name with a 4 digit number in the brackets. Is there a way to add another outcome to the if statement?

Aucun commentaire:

Enregistrer un commentaire