Forum Discussion
Using IF functions to merge multiple formulas
I have two scenarios that I need help with. 1. Removing an alpha character from a string that can be at the beginning or the end. Column B value in this case is R24615 or could be (for example)...
orglenda1740
1. Revised formula
=IF(ISNUMBER(LEFT(B1,1)*1), LEFT(B1, LEN(B1)-1), RIGHT(B1, LEN(B1)-1))
2. Combined formula:
=IFERROR(IF(LEFT($F10,3)="986", RIGHT($F10,3), RIGHT($F10,3)*LEFT($F10,3)), "")
Rodrigo_ Thank you for your help.
