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